Search found 6797 matches

by DSguru2B
Wed Jun 28, 2006 9:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Join stage
Replies: 7
Views: 4361

check this post for reference.
by DSguru2B
Wed Jun 28, 2006 9:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: aborted and aborted/restartable
Replies: 3
Views: 1784

If your sequence is restartable, why do you need to reset it. You dont want to do that if you want to retain its checkpoint history. Just fire the sequence again and it will handle it on its on. Yes if you want you can reset the individual job which failed but that can be controlled from within the ...
by DSguru2B
Wed Jun 28, 2006 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Update SQL Query
Replies: 18
Views: 4048

Let it change. You need to pass that as an extra column to your Database stage as a key. No one is asking you to parametrize it.
by DSguru2B
Wed Jun 28, 2006 7:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Update SQL Query
Replies: 18
Views: 4048

As Ken mentioned, do you transformation as you will. While sending it to the update, specify all the conditions as keys. That will take care of it.
by DSguru2B
Wed Jun 28, 2006 7:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to open csv file format
Replies: 22
Views: 9680

There are softwares present out-there that can do the conversion for you. Renaming the file doesnt change its structure internally. As your OS is windows, you can access the workbooks by creating an odbc connection.
Regards,
by DSguru2B
Wed Jun 28, 2006 7:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Update SQL Query
Replies: 18
Views: 4048

Need more info on how did you get the number 30. Are you aggregating the dept grouped by ENAME and then want to go into the table and update all dept keyed on ENAME?
Need more clarification on your requirement.
by DSguru2B
Wed Jun 28, 2006 6:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to pass values without human intention
Replies: 2
Views: 705

I like the subject. Gives an evil vibe :twisted:
by DSguru2B
Wed Jun 28, 2006 6:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding ERROR
Replies: 2
Views: 729

Do an exact search on "Type 30 descriptor". You will find 16 posts relating to that problem.
by DSguru2B
Tue Jun 27, 2006 2:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Raising an error
Replies: 11
Views: 5592

Use a job sequence. Create two jobs. The first job creates the sequential file with the value 123. In the second job, use a job parameter for that value say #val#. For the derivation of that job property, fire a simple routine, a basic routine to open and read the value of that sequential file. I th...
by DSguru2B
Tue Jun 27, 2006 2:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Array Size problem
Replies: 23
Views: 5483

Dont worry about it. Its all good. I know, sometimes issues can really be frustrating. But we are all here to learn.
Dont worry about it gateleys.
Have a nice day :P
by DSguru2B
Tue Jun 27, 2006 1:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Progress and MFGPRO
Replies: 6
Views: 1176

Did you try the link i provided.
by DSguru2B
Tue Jun 27, 2006 1:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to execute more commands in the Before/After Job routine
Replies: 4
Views: 1706

Build a small script for that and fire that script from the before/after job subroutine section using ExecSh
by DSguru2B
Tue Jun 27, 2006 1:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Progress and MFGPRO
Replies: 6
Views: 1176

Do an exact search on Progress. You will see quite some posts. That means that Progress is present in the environment for quite some posters here.
Try this post for a start
by DSguru2B
Tue Jun 27, 2006 12:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX warning in Oracle Enterprise stage
Replies: 14
Views: 6702

Can you paste the schema that you have imported.
by DSguru2B
Tue Jun 27, 2006 12:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Raising an error
Replies: 11
Views: 5592

You may want to write a small routing to do the required check. Below is an apsert from Datastage help: Logs a warning message in a job's log file. Syntax Call DSLogWarn(Message,CallingProgName) Message (input) is the warning message you want to log. Message is automatically prefixed with the name o...