That works. I defined this kind of columns as VarChar and manipulated the data within transformer basing on whether I have '+' sign or '-' sign.
Good Luck,
Aruna.
Search found 143 matches
- Thu Oct 23, 2008 3:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: explicit decimal point in CFF
- Replies: 3
- Views: 1144
- Tue Oct 14, 2008 2:25 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: profiling time and space ?
- Replies: 7
- Views: 6245
- Thu Oct 09, 2008 2:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CFF Stage
- Replies: 1
- Views: 1645
Somewhere the schema became incompatible with data. Make sure your output schema has all the columns you are trying to map. Just a manual comparison of data with fields in the output column should help you. Because usually formatting arrays is simple with CFF stage. Usually it is the Comp fields map...
- Thu Oct 09, 2008 2:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: working the Mainframe data
- Replies: 3
- Views: 1444
As you are working on version 8, you can use Complex Flat File Stage to read VSAM data from Mainframe. There should be couple of posts ( I created one of those ) that explain how to do this. If you have federation server you can directly connect to VSAM files from DataStage. Otherwise you have to co...
- Thu Oct 09, 2008 2:20 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: IA and Mainframe DB2
- Replies: 1
- Views: 2514
- Thu Oct 09, 2008 2:17 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: ODBC for IA
- Replies: 6
- Views: 5733
For fixing the security mechanism error please try adding 'SecurityMechanism=1' in your .odbc.ini file. We had same issue which was ressolved after adding this to odbc.ini file. [IADB] QEWSD=39695 Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb222.so Description=DataDirect DB2 Wire Pr...
- Thu Oct 09, 2008 1:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion error calling conversion routine date_from_string
- Replies: 8
- Views: 21682
- Thu Oct 09, 2008 1:20 pm
- Forum: General
- Topic: Warning converting decimal to date
- Replies: 6
- Views: 4621
- Thu Oct 09, 2008 1:18 pm
- Forum: General
- Topic: Warning converting decimal to date
- Replies: 6
- Views: 4621
- Tue Sep 30, 2008 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IS connectivity to Netezza error
- Replies: 6
- Views: 9456
- Tue Sep 30, 2008 10:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IS connectivity to Netezza error
- Replies: 6
- Views: 9456
- Tue Sep 30, 2008 10:04 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Information Analyzer
- Replies: 5
- Views: 4513
Check and see what kind of errors you are getting in iashandler.log. You can find these logs in '/usr/WebSphere/AppServer/profiles/default' directory. Also you can check for any errors in Client directory 'C:\IBM\InformationServer\Clients\ISC'. Either of these logs should tell you what is the exact ...
- Tue Sep 30, 2008 7:50 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Information Analyzer
- Replies: 5
- Views: 4513
Yes. The column analysis jobs do tend to run for several hours depending on the volume of data and number of fields. But instead of killing your job, you can check the status of the column analysis jobs on Director by selecting 'ANALYZERPROJECT' project. By checking the status of column analysis job...
- Tue Sep 30, 2008 7:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IS connectivity to Netezza error
- Replies: 6
- Views: 9456
I don't think getting a reply for this post should be the sole reason for you to become premium member as there are several other benefits you can derive being a premium member. But here is what I think you may be missing. You need to have a soft link odbc.ini in your $DSHOME that points to .odbc.in...
- Mon Sep 29, 2008 10:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to save the job
- Replies: 7
- Views: 2550