Search found 6797 matches

by DSguru2B
Fri Mar 16, 2007 2:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: C Language Implementation
Replies: 4
Views: 844

If its just if then else statments then you can write that in a stage variable inside the transformer. I dont think you should have any problem.
by DSguru2B
Fri Mar 16, 2007 2:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migration 7.5x2 to 8.0
Replies: 15
Views: 4088

Best to get in touch with support as 8.0 is still new in the market and not very many users.
by DSguru2B
Fri Mar 16, 2007 2:04 pm
Forum: General
Topic: books for datastage
Replies: 5
Views: 2530

Welcome Aboard
No book on datastage. The closest you can get is manuals. If your new, you need formal training and/or guidance.
by DSguru2B
Fri Mar 16, 2007 1:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datawarehousing
Replies: 4
Views: 1246

For implementing datawarehouses, wow, thats a huge conversation. I suggest you read Ralph Kimbal or Inmon books.
A source stage can handle any amount of data, there is no limitation.
If you divide it in chunks, thats ok. This way you can extract in chunks by utilizing multiple instance jobs.
by DSguru2B
Fri Mar 16, 2007 1:33 pm
Forum: General
Topic: string replacement in mainframe job
Replies: 8
Views: 1992

If it really is a mainframe job. The OP has another duplicate post in the px forum.
by DSguru2B
Fri Mar 16, 2007 10:39 am
Forum: General
Topic: string replacement in mainframe job
Replies: 8
Views: 1992

Thats right we dont. We only have MVS job type. Sorry, my bad. If its a px job then there are certain ways this can be done. For instance if your column is of type varchar, do StringToDate(in.PWD) It will not fit the date format and hence give you stars. If the field can have less character...
by DSguru2B
Fri Mar 16, 2007 10:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi instance Job gets Deadlocked on windows platform
Replies: 4
Views: 2329

I have seen this error before. I did nothing, just re-ran the job and it was fine. My DBA couldnt tell what really happened as the error did'nt reproduce the next time.
Try re-running the job again.
by DSguru2B
Fri Mar 16, 2007 10:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: /TMPDIR - More Information Needed
Replies: 10
Views: 3943

So now you have to make sure your jobs finish within 3 days :?
by DSguru2B
Fri Mar 16, 2007 10:10 am
Forum: General
Topic: string replacement in mainframe job
Replies: 8
Views: 1992

Are you using MVS version? If yes please post in that forum? If not then please explain.
If your using px then you can do replacement in the transformer using different functions.
by DSguru2B
Fri Mar 16, 2007 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Select the record with 0x0 inside the field by using Filter
Replies: 20
Views: 5509

No, I meant before feeding into the filter stage, make sure the data has '0X0' in it.
by DSguru2B
Fri Mar 16, 2007 8:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: /TMPDIR - More Information Needed
Replies: 10
Views: 3943

I would say any OS level activities would use the tmp directory like sorting etc. by default. Other processes occupy specific directories present in the Project home directory.
by DSguru2B
Fri Mar 16, 2007 7:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Application Error Designer closes
Replies: 22
Views: 5364

Guru sounds a lot easier then all :wink:
by DSguru2B
Fri Mar 16, 2007 7:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: shell variable
Replies: 2
Views: 803

Where is this shell variable present? Use a routine to invoke the file that sets this shell variable and within the same routine read the value using echo $SHELLVARIABLE. It will spit out the value. All this can be done using DSExecute() within a routine.
by DSguru2B
Fri Mar 16, 2007 6:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Select the record with 0x0 inside the field by using Filter
Replies: 20
Views: 5509

Please verify that you are actually getting the desired result out of the source before jumping to the statement " It does'nt work".