Search found 6797 matches

by DSguru2B
Wed Dec 06, 2006 1:14 pm
Forum: General
Topic: executing a stored procedure
Replies: 12
Views: 6330

Where are you trying to execute this procedure?
If in datastage then in what stage?
by DSguru2B
Wed Dec 06, 2006 1:08 pm
Forum: General
Topic: Using dsjob command
Replies: 3
Views: 2800

Welcome Aboard dsjob command does a variety of different things depending upon what you want it to do. Search this forum and look into your help docs. You will find everything you are looking for. As a newcomer advice, use the search facility before posting up a question. You will be amazed by the a...
by DSguru2B
Wed Dec 06, 2006 12:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generic Stage
Replies: 4
Views: 1907

He cannot delete his post anymore once it has trailing posts.
by DSguru2B
Wed Dec 06, 2006 10:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reply = 9 error in Execute_Command stage
Replies: 17
Views: 4151

Finally you posted the message that i asked you for. Obviously its not able to recognize those folders or the id your using to run this job does not have access to these folders. You sure its the correct syntax. I dont see any file in fld1/fld2/fld3/ I dont see the file name in /fld1/fld2/fld3/.zip ...
by DSguru2B
Wed Dec 06, 2006 10:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Conversion
Replies: 1
Views: 614

Click here.
Go to the last post by Ray and follow his advice. You will be a happy man :wink:
by DSguru2B
Wed Dec 06, 2006 10:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email notification for all job in a sequence
Replies: 12
Views: 3185

Ok, try to find out your smtp server. It is the same as your outlook. On second thought, do this Go to your outlook, go to tools click on Email accounts Choose the option "View or change existing accounts" There will be only one name listed which is of type "Exchange (Default)", highlight that and c...
by DSguru2B
Wed Dec 06, 2006 10:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Collector Failing
Replies: 1
Views: 463

Are you reading or inserting these rows to the oracle table. Somewhere in the process, your network connection disconnected. This is what i got from google ORA-03113: end-of-file on communication channel Cause: The connection between Client and Server process was broken. Action: There was a communic...
by DSguru2B
Wed Dec 06, 2006 9:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email notification for all job in a sequence
Replies: 12
Views: 3185

Ask your LAN admin for that. It will be same server that your outlook is setup on.
by DSguru2B
Wed Dec 06, 2006 7:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error handling
Replies: 5
Views: 1381

Error handling is different than debugging. Google on the keywords to get exact definitions.
Also, DRS stage is a stage and not a third party tool.
by DSguru2B
Tue Dec 05, 2006 1:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with trimming the filed value
Replies: 8
Views: 1746

Mulitpy it by 1 to get an implict conversion to integer.
by DSguru2B
Tue Dec 05, 2006 1:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding universe command utility
Replies: 9
Views: 1624

Never heard or saw SORT.DICT
I know there exists SORT.LABEL and SORT.ITEM which use the reserved word DICT but not SORT.DICT.
But then again i am not a Universe guru. Still learning :)
by DSguru2B
Tue Dec 05, 2006 1:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reply = 9 error in Execute_Command stage
Replies: 17
Views: 4151

11:08:38: Execute_Command_1 (COMMAND unzip) started 11:08:38: Execute_Command_1 finished, reply=9 Double click both those entries in the director's log and paste here whatever you see. I want to see the output of that command. Also, what are the values that are passed for #FilePath# and #FileName#....
by DSguru2B
Tue Dec 05, 2006 1:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reply = 9 error in Execute_Command stage
Replies: 17
Views: 4151

Ok. Still cannot help you. Instead of trying to guess how your trying to do, provide me the following -The exact error message or the exact message from the exectue command stage. Double click it and get the log detail. -the gzip command or/and script text your providing for the execute command acti...
by DSguru2B
Tue Dec 05, 2006 1:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reply = 9 error in Execute_Command stage
Replies: 17
Views: 4151

How are you trying to do that in the script?
Need to take a look at your script.
by DSguru2B
Tue Dec 05, 2006 1:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reply = 9 error in Execute_Command stage
Replies: 17
Views: 4151

Re: reply = 9 error in Execute_Command stage

That was a joke. And after that i asked for more details as this much info is not enough to diagnose the problem.