Search found 42189 matches

by chulett
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

You'll need to be a wee bit more specific than "some space issue" if you need more help.
by chulett
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

... or something (hopefully) more obvious like '0x20'. :wink:
by chulett
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

Not seeing any evidence that this is anything related to a web service, I moved the post here.
by chulett
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...
by chulett
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...
by chulett
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...
by chulett
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...
by chulett
Fri Jun 03, 2011 7:01 am
Forum: General
Topic: Exporting PROJECT in XML format
Replies: 14
Views: 4897

dscmdexport does an entire project.
by chulett
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.
by chulett
Thu Jun 02, 2011 9:21 pm
Forum: General
Topic: Error with DSRoutine
Replies: 7
Views: 2193

OK... what happens when you change the code as I mentioned?
by chulett
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

There's typically just one but the limit on the max number of and/or rate of connections could be too low. Depends on how this "connectivity issue" manifests itself.
by chulett
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

Patience, Grasshopper. And learn to use the Reply to topic link rather than quoting everything every time for no reason.
by chulett
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...
by chulett
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

Define "connectivity issue".
by chulett
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

A "horizontal pivot" specifically... columns to rows.