Enzee Universe

Getting SQLException ,I Expect BatchUpdate Exception

vgss — Mon, 23 Aug 2010 17:33:47 GMT

Hi,

following is my code, I am using netezza JDBC driver 5.0.10,this driver support BATCH UPDATES, so with the following code i should get BatchUpdateException but I am getting SQLException would any one please help me.I am first time working with Netezza

try{

for(String dBstat: DbStatments)

{

statement.addBatch(dBstat);

}

noOfRecordsUpdated=statement.executeBatch();

}

catch(BatchUpdateException bue)

{

logger.error(bue.getMessage());

}

catch(SQLException sql)

{

logger.error(sql.exception);

}

Access Netezza using JDBC

vgss — Fri, 13 Aug 2010 13:21:48 GMT

Hi,

would any one please tell me how to get the list of SQLErrorCODES netezza will return

Thx

Netezza SQL ERROR Codes

vgss — Tue, 10 Aug 2010 19:16:18 GMT

Hi,

I am trying to access Netezza from my JDBC code, would any one please tell me as where can I look for NETEZZA SQL ERROR CODES

THX

vgss

Encryption of data between Oracle and Netezza

Dallas — Sat, 15 May 2010 04:07:02 GMT

We have data in Oracle and Netezza, planning to encrypt some fields on both the platforms.

Does any one has experience in using AES 128 or AES 256 (advanced encryption) on both the platforms.

If so is it compatible.

For Example : if an encrypted values is sent from oracle to entezza with the same key, is the value decrypted properly.

Regards

Select data from table insert into flat file...

sriband — Tue, 25 Aug 2009 22:21:31 GMT

I am using below sql to load the data from flat file to Netezza

INSERT INTO A
SELECT * FROM EXTERNAL 'c:\data\a.txt'
USING ( BOOLSTYLE '1_0' COMPRESS FALSE CRINSTRING FALSE CTRLCHARS FALSE DATEDELIM '-' DATESTYLE 'YMD' DELIMITER 'TAB' ENCODING 'latin9'
FILLRECORD FALSE IGNOREZERO FALSE LOGDIR 'c:\data'
MAXERRORS 1 MAXROWS 0 NULLVALUE 'NULL' QUOTEDVALUE 'NO' REMOTESOURCE 'jdbc' REQUIREQUOTES FALSE SKIPROWS 0
SOCKETBUFSIZE 8388608 TIMEDELIM ':' TIMEEXTRAZEROS FALSE TIMESTYLE '24HOUR' TRUNCSTRING FALSE Y2BASE 0)

I want in reverse order I mean I want select the data from table and place in flat file.

Please some one could help me.

thanks

Babu

ERROR [08S02] Unexpected protocol character/message

sriband — Tue, 25 Aug 2009 21:48:47 GMT

Hi .

I am .Net [C#] developer and using Netezza as database in my Latest application.

I wrote a small application to get the data from Netezza and using odbc driver.

Its returning the rows and in middle I am getting below msg.

ERROR [08S02] Unexpected protocol character/message

System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcDataReader.Read()

Source is nsqlodbc.dll.

Please some could help me.

thanks

Babu

Sync problem from SQL Server to Netezza

sriband — Mon, 17 Aug 2009 20:00:43 GMT

Hi Good Monring all,

We are syncing the Data from SQL Server to Netezza and some special charactes are not converting

For Example -

MC21-‘90s [SQL Server] MC21-?90s [Netezza]

Please can some one help me

thanks

Data Integration Musings!!!!!!!!!

gsnraj1@gmail.com — Sat, 13 Jun 2009 03:49:41 GMT

Wonder Why Wonder How!!!!!!!!!!!!!!

Am Raj Guthikonda I've been a Chief Architect in th Oracle BI & Data warehouse arena

This blog post is my initial musingin the Netezza arena to do soe thought provocation

I wonder why data has so many silos and how can we overcome this silos

Business data is an invaluable commodity in today's fast changing analytic World where we figure out how to beat our customers & how can we leverrage the data that a business has

I have been recently associated with one of the biggest financial services mergers in the mid atlantic region of greater Pittsburgh area

This client of mine was using an analytics tool / application coming from a formidable provider who has the chunk o the market share

but we lacked te basic adapters to bring in the data from various types of data sources such as VSAM & IDM

I hope the next level determining a best of breed business intelligence data base server or the tool should have all this great features where in we can overcome the application silos and build our enterprise wide data warehouses in an efficient way

The next breed should have great analytics capabilities great user interfaces and also could be used to do data integration & data quality assessments

The Future of Financial Reporting XBRL

gsnraj1@gmail.com — Mon, 19 Jan 2009 02:52:05 GMT

The Future of Financial Reporting & Dashboarding

This are my view points on the next generation of Financial reporting:

The present day financial & banking investor has grown into a vehicle for a stricter pragmatic approach towards financial reporting focussing on publicly held companies after the debacle of major fannie mae & livedooor to name a few.

Financial account AVP's & executives need to understand & adapt to a more demanding approach of the investors hence to suceed the companies need to understand this new requirements & leverage the compliance factors to enhance transparency.

in the present day a stakeholder is no more a novice he is interested in knowing how the companies are run at a dogma level for example he is interested in knowing how much is an executive paid, what are the costs associated with social & charitable initiatives by the company & more.

This change in the investors thought process had lead to major compliance initiatives like SOX, J SOX, & Basel two t name a few, this compliances have lead to to a more novel concentration of stake holders on indices depending up on corporate governance, integrity of the audit process, executive compensation & stock ownership.

Now one of the primary initiatives in the past few Years are IFRS reporting based upon the directives of International accounting standard board (IASB) which is music to the ears of prospective investors & stack holders as they can analyze & invest in the companies with more confidence at the same point in time this structure brings more complex requirements for the account executives etc.

So the FASB & IFRS are focussing on a principles based approach rather than a rule based one & this makes the financial executives uneasy due to complex processes but at the same time IFRS has a fair value accounting approach where in assets & liabilities are marked to a market proposition or value rather than a historical value.

So the core focus of investors has been to gain an insight into the financial & non financial metric's of business continuity to maintain the business and sustain the business in a long run.

A large chunk of the fortune companies like Alcoa, PNC, Citigroup, Kia, Walmart to name a few are now interested in having a better public image so they are also interested in business indicators & metric's belonging to social activities such as diversity hiring, working conditions work force retirement etc

“ACHTUNG BABY”

So here comes the pivotal point ( Ice cream for our thought) of this musing & success

What is the next generation of financial reporting?

Well to me it seems like XBRL which comes from the family of XML which is a taxonomic hierarchical semantic tagged based markup language built upon formula, XML elements & XSLT transformations.

Source: www.XBRL.org

So lets look at a sample XBRL code snippet

<formula:formula xlink:type="resource" xlink:label="formula" implicitFiltering="true" aspectModel="dimensional" source="eg:variable1">

<formula:aspects>

<formula:entityIdentifier value="'AXYZ-1234'"/>

</formula:aspects>

<formula:aspects source="eg:variable 2">

<formula:period/>

<formula:unit source="eg:variable3">

<formula:AddBy source="eg:variable4"/>

</formula:unit>

</formula:aspects>

</formula:formula>

So basically here our source variable which is “1” Source

Variable 2 is an period entity

Variable 3 is a unit entity &

Variable 4 is a additive entity

So the next generation of best of breed reporting architectures may be built on this uniformed reporting language known as XBRL

So the best practices for the next generation of financial reporting :-

Actively participate towards the XBRL community.
Storing the Business specific data in XBRL format for reporting.
Oracle, Netezza, Cognos etc should Leverage this standard of financial reporting architecture and should come up with novel ideas of sourcing tis data into their business intelligence tools.
Building a compliant & competent Business Intelligence tool that could leverage upon XBRL format & access the XBRL data in to the Business Model & Mappings.
Reduce the dependency on excel reporting it is known to the Oracle business Intelligence community that the most replaced tool today in the market for business data analysis & financial analysis is MS Excel.
Aligning the process of sourcing & collecting the operational results, financial results, social results & environmental results into a unified process.

Disclaimer:

This are my basic view points on the best practices as an individual.

References: Dowjones Sustainability Indices

Standard & Poor's

www.xbrl.org

www.oracle.com

IFRS & IABS website