Search found 42189 matches

by chulett
Fri Oct 02, 2009 3:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Windows to Unix transitioning question
Replies: 6
Views: 1421

Odd. :?

Can you post your routine source and if you have a log entry that shows the actual command being executed could you post that as well? Also, is "/g_drive" an NFS mount off a Windows server by chance?
by chulett
Fri Oct 02, 2009 2:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Windows to Unix transitioning question
Replies: 6
Views: 1421

'cp sourcepath/* targetpath'
by chulett
Fri Oct 02, 2009 2:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot find job TEST
Replies: 12
Views: 3751

The issue with job 1775 has been resolved. >CNAME RT_CONFIG1775 TO RT_CONFIG1775BAK Unable to open file "RT_CONFIG1775". Changed "RT_CONFIG1775" to "RT_CONFIG1775BAK" in your VOC file. (at this point I manually renamed the directory under the project in another session)...
by chulett
Fri Oct 02, 2009 2:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing Hash file through Universe Stage
Replies: 21
Views: 5407

I don't really see a downside except for the fact that the quote-unquote "advanced" nature of the solution may be outside of people's experience. Make sure you put a big annotation on the canvas explaining what you did. Heck, you could even include a URL to this post in it! :lol: One thing...
by chulett
Fri Oct 02, 2009 1:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String toDate conversion
Replies: 3
Views: 1168

So your output is yet-another string or is it actually a Date field? For the former you'd need to combine StringToDate() with DateToString() to get the desired external representation of the date. Only the former is needed for the latter, if that makes sense. Meaning, you only need the StringToDate(...
by chulett
Fri Oct 02, 2009 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS adding decimal points
Replies: 5
Views: 1116

:idea: You could have posted fake data that is representative of the problem, doesn't need to be "real real" as long as it illustrates the issue accurately. DataStage has no knowledge of implied decimals so defining them that way is going to get you a value that is 100x the original value ...
by chulett
Fri Oct 02, 2009 1:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS adding decimal points
Replies: 5
Views: 1116

Post some examples of your input and output data, plus let us know how the field is defined on both ends and what transformation you are doing, if any.
by chulett
Fri Oct 02, 2009 12:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing Hash file through Universe Stage
Replies: 21
Views: 5407

OK, I have a working job doing exactly what we talked about. Let's see if I can make what you need to do more clearer. Yes, you need to "add Year as a column" to the UV stage. That doesn't mean there is actually a column with that name, we just need it as a mechanism to bring the value int...
by chulett
Fri Oct 02, 2009 12:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Missing delimter and non ascii characters in the file
Replies: 6
Views: 2101

You can move it over to your desktop and use a hex editor or from the UNIX side try an "od -h" on the file and post the results. There are many free hex editors out there to try. For the "od" command, probably best to use it on a file with just that one record in it, if possible.
by chulett
Fri Oct 02, 2009 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Missing delimter and non ascii characters in the file
Replies: 6
Views: 2101

Can you let us know what the hex values are for the 'weird' characters?
by chulett
Fri Oct 02, 2009 10:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Name of the process running
Replies: 3
Views: 860

Hmmm... then perhaps a chat with your SysAdmin is in order.
by chulett
Fri Oct 02, 2009 10:21 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Basic Question on SOA
Replies: 3
Views: 3038

It is "running" waiting for input, for the service to be called / invoked. Think of it like you in your car, sitting at a red light with your foot on the brake. Invocation is the green light and the road is the data it was sent to process... until you are done and stuck idling at the next ...
by chulett
Fri Oct 02, 2009 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Name of the process running
Replies: 3
Views: 860

You should be able to check /etc/services for that information.
by chulett
Fri Oct 02, 2009 10:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS upgrade from v7.5.1 to v7.5.3
Replies: 4
Views: 1955

Just double-checked and it's actually called multiserv.pdf in your Docs directory.
by chulett
Fri Oct 02, 2009 10:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file view
Replies: 6
Views: 1904

The old Universe manuals that (I believe) you can still find somewhere out on IBM's website.