Search found 21 matches
- Wed May 21, 2014 5:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "Unstructured Data" stage reads excel data wrongly
- Replies: 4
- Views: 6640
We faced the same issue and the resolution was in Excel. As the data had been in some point of time in numeric format in the column Excel refused to make it text. The workaround was to create a new column, make it as text, then copy data from old column to Notepad and finally copy the data back to n...
- Thu Jan 27, 2011 7:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector behavior on connection parameter
- Replies: 7
- Views: 4851
- Wed May 19, 2010 12:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 8.1 is behaving differently than 7.0
- Replies: 1
- Views: 1832
Hi, IBM did fix numerous bugs in version 8 concerning Oracle OCI stage and one aspect especially affected with those fixes was date-conversions. I actually stumbled myself into a similar problem and the fix was quite straight forward even though quite annoying: As the actual data type in the Oracle ...
- Mon May 10, 2010 3:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: AS/400 data type mismatch during metadata import
- Replies: 1
- Views: 2298
As I tumbled myself recently into this same problem I'll post my solution here. In AS400 data can be stored in CHAR() FOR BIT DATA -format that requires translation before it is shown correctly in DataStage. In order to make the translation you must tell the odbc-driver which character set is used i...
- Fri Nov 10, 2006 2:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Strange error in Teradata Ent. Stage (read)
- Replies: 9
- Views: 4648
- Fri Apr 28, 2006 4:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pin1 not initialized -error
- Replies: 10
- Views: 8738
- Solved
Hi everybody, just to post the cause of the problem: Anti virus software Yes, I know it should be obvious to check this out first but we had done the same exercise couple of months ago with same kind of mysterious problems. The end result back then was not to include project folder in the virus scan...
- Thu Apr 20, 2006 11:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pin1 not initialized -error
- Replies: 10
- Views: 8738
- Tue Apr 18, 2006 1:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pin1 not initialized -error
- Replies: 10
- Views: 8738
Hi ArndW and thanks for the response. I was also thinking the problem must be with DS_STAGETYPES as this is always referred to in error messages. I ran DS.REINDEX and it went smoothly - no warnings and all three indices with build status Not Reqd. And worst of all - the problem didn't go anywhere (w...
- Tue Apr 18, 2006 9:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pin1 not initialized -error
- Replies: 10
- Views: 8738
Pin1 not initialized -error
I have a job where I load five hashed files from five Oracle tables. There are ten to twenty of these jobs. Lately I have stated to experience problems with these jobs failing with following error messages. I tried to reindex DS_STAGETYPES as I though it might have something to do with that but that...
- Wed Sep 14, 2005 6:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML file loading
- Replies: 5
- Views: 2659
Check that you are NLS-enabled and the folder stage is set to read UTF-8 if the xml file is defined to be utf-8 encoded. Other way to do it is to set the FileName as input column for the xml stage (In folder stage remember to set the Fully qualified -property to Yes). Then in the xml stage set the i...
- Thu Apr 28, 2005 2:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Row Splitter
- Replies: 4
- Views: 2876
It should be there. I just checked my DS 7.1. On the bottom left corner... Precious: At least I haven't managed to put the passthrough columns in the begining of the output columns. I think it is the way row splitter works that it first splits the column specified and only after it runs out of data ...
- Tue Apr 26, 2005 2:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Row Splitter
- Replies: 4
- Views: 2876
- Mon Apr 04, 2005 5:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning message on "dfloat" when using a aggregato
- Replies: 6
- Views: 11901
What you have bumped into is the underlying heavily typed parallel engine. The aggregator operator is coded so that it will output its results as dfloat. Now that you have explicitly stated that you want it as integer the engine will do a default conversion from dfloat to integer. This kind of conve...
- Tue Mar 01, 2005 2:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Failed to connect to JobMonApp
- Replies: 2
- Views: 2178
- Fri Dec 03, 2004 2:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parameters from File Routine. Password Encrytion Issues
- Replies: 6
- Views: 4561
Hi NEO, I came across the same problem recently and I found out that routines just pass the parameter values as they are. I found two ways to get around that: 1. Use encrypted string as input to the routine. This can be found for example from the Director log or when scheduling a job. I.e. if you se...