Search found 6797 matches

by DSguru2B
Mon Jan 29, 2007 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when checking composite operator: Subprocess command
Replies: 8
Views: 4360

What is the length of source and target for that particular field?
by DSguru2B
Mon Jan 29, 2007 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number of rows in a data set
Replies: 23
Views: 5240

abc123 wrote:My dsenv file does not have a SHLIB_PATH. There is a LD_LIBRARY_PATH. Am I getting this error due to not having SHLIB_PATH in my dsenv file?

NO. You need either one of those. If your on HP-UX only then you will need SHLIB_PATH. I think the rest of the platforms use LD_LIBRARY_PATH.
by DSguru2B
Mon Jan 29, 2007 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OLE SERVER CONNECTIVITY
Replies: 5
Views: 2550

Try re-installing the client. It should clear up on its own. As Ray noted, its not that frequent.
by DSguru2B
Mon Jan 29, 2007 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when checking composite operator: Subprocess command
Replies: 8
Views: 4360

Look into this message ##W TFCP 000025 16:01:38(003) <transform> Error when checking composite operator: Possible range limitation. ##W TFCP 000000 16:01:38(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type ...
by DSguru2B
Mon Jan 29, 2007 3:12 pm
Forum: General
Topic: receiving notification when a job fails
Replies: 7
Views: 3235

I have the same screen resolution, and my eyes are 6/6. It was just an innocent comment :roll:
I can read it but its, small.
by DSguru2B
Mon Jan 29, 2007 2:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL1652N : File I/O error occurred
Replies: 34
Views: 16058

Are you doing extracting and loading both in the same job? If yes then check that both input and output tabs of the sequential file have identical file names.
by DSguru2B
Mon Jan 29, 2007 2:55 pm
Forum: General
Topic: receiving notification when a job fails
Replies: 7
Views: 3235

chulett wrote:(does Roy even care where we say to move them? I would guess he just uses his own good judgement)


I need a magnifying glass to read that.
by DSguru2B
Mon Jan 29, 2007 2:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTPing Multiple Files with Parameters
Replies: 11
Views: 3299

Good catch velgapudi_k. Even i missed that the first time. The OP cant get away with it, he will have to fix it or else he will get warning messages saying that the variable was not intialized.
by DSguru2B
Mon Jan 29, 2007 2:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Options bar in Designer Window
Replies: 9
Views: 1870

It must have hidden somewhere towards the bottom of your screen or towards on the sides. Well, you found it now, enjoy.
by DSguru2B
Mon Jan 29, 2007 2:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automize the process of Excel to csv/txt conversion
Replies: 3
Views: 947

Search this forum for some ideas. This has been discussed here before.
by DSguru2B
Mon Jan 29, 2007 2:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTPing Multiple Files with Parameters
Replies: 11
Views: 3299

I am sure it will. Thanks for sharing it with us :P
by DSguru2B
Mon Jan 29, 2007 12:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to create parallel routine?
Replies: 10
Views: 5699

Are you just playing around with c routines ? Hardly you have to write an external C function. The px functions library is rich with differnt functions to achieve many tasks. You either habe gCC or aCC. Both may not work. Try to write a simple "HELLO WORLD" program, that you can get off the net and ...
by DSguru2B
Mon Jan 29, 2007 12:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Logic for extract generation
Replies: 8
Views: 1857

Its a plain and simple concept. It will be trigger for insert that will scan the table for incoming pk. If the pk is found and the EFFECTIVE_END_DATE is NULL then it will update the record and put current timestamp for EFFECTIVE_END_DATE and insert the new record with NULL. If you are not familiar w...
by DSguru2B
Mon Jan 29, 2007 11:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage date in sql query
Replies: 10
Views: 5415

chulett wrote:DSJobStartDate would, perhaps, be a better choice. :wink:

O yea, just date, sorry. Me a grasshopper :roll: