Search found 42189 matches
- Sat Jun 04, 2011 7:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: padstring issue while loading into Netezza Database
- Replies: 7
- Views: 2865
- Fri Jun 03, 2011 5:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: padstring issue while loading into Netezza Database
- Replies: 7
- Views: 2865
- Fri Jun 03, 2011 1:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to Perform Not Equal Join
- Replies: 5
- Views: 2092
- Fri Jun 03, 2011 8:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File Data in Table Column
- Replies: 11
- Views: 3463
While Ray, being a Founding Father and all, may just know what the character is mere mortals like you and I need to figure it out... and it seems you already have. Your problem is you are dumping the value in octal, convert it to or dump it in decimal and then use that value along with Char() when y...
- Fri Jun 03, 2011 7:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File Data in Table Column
- Replies: 11
- Views: 3463
So... why two jobs? I made the silly assumption that you were doing everything all at once (hence my suggestion), don't really see the point of reading the file using the Folder stage only to write it back out again to yet another sequential file. Any particular reason your first job can't do the lo...
- Fri Jun 03, 2011 7:19 am
- Forum: General
- Topic: Exporting PROJECT in XML format
- Replies: 14
- Views: 4897
Check the docs or search here, I seem to recall it can optionally do either. Why XML? It makes imports more painful, especially at the 'whole project' level as under the covers all that XML must first be converted to DSX format and then imported. That conversion is slow and takes a great deal of mem...
- Fri Jun 03, 2011 7:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle NLS_NUMERIC_CHARACTERS setting in Datastage 8.5
- Replies: 5
- Views: 3849
Thought we were talking about a problem with your jobs rather than a specific tool. If you have it set in your dsenv file and source it before running the utility - that or set it explicitly in your user's environment - and it doesn't affect the behaviour of orchdbutil, then perhaps you should conta...
- Fri Jun 03, 2011 7:01 am
- Forum: General
- Topic: Exporting PROJECT in XML format
- Replies: 14
- Views: 4897
- Fri Jun 03, 2011 6:58 am
- Forum: General
- Topic: Datastage export XML
- Replies: 1
- Views: 2489
Yes and it has been discussed here before. Phil Hibbs has a utility that includes that ability.
- Thu Jun 02, 2011 9:21 pm
- Forum: General
- Topic: Error with DSRoutine
- Replies: 7
- Views: 2193
- Thu Jun 02, 2011 7:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sybase to Oracle
- Replies: 6
- Views: 1865
- Thu Jun 02, 2011 7:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File Data in Table Column
- Replies: 11
- Views: 3463
- Thu Jun 02, 2011 7:43 pm
- Forum: General
- Topic: Error with DSRoutine
- Replies: 7
- Views: 2193
Without knowing what your batch file is doing, still hard to offer much cogent advice. However... add a check of the error code and call DSLogInfo() in the routine to log what comes back. You'll also need to pick up on the fact that, as gets mentioned here over and over, output from DSExecute can be...
- Thu Jun 02, 2011 2:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sybase to Oracle
- Replies: 6
- Views: 1865
- Thu Jun 02, 2011 1:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting a single row to multiple rows
- Replies: 5
- Views: 2244