Search found 6797 matches

by DSguru2B
Tue Oct 17, 2006 5:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Testing For A Valid Date
Replies: 8
Views: 1946

Search this forum for DEFFUN. Here is a starter
by DSguru2B
Tue Oct 17, 2006 5:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to eliminate duplicate records from source
Replies: 6
Views: 1588

This smells like an interview question. If not, then give me more details, your source, is it a flat file or a database, why do you want to avoid using those stages? Any particular reason.
by DSguru2B
Tue Oct 17, 2006 5:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can we execute jobs uing unix
Replies: 2
Views: 797

Yes. dsjob -run is the command you are looking for. Search this forum for more examples and exact syntax.
by DSguru2B
Mon Oct 16, 2006 1:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Log explaination
Replies: 3
Views: 616

I am not using Metstage nor Sequencer.
Even if I try to run a simple job that tests my connection with the Oracle database by selecting 1 from dual. That Job too is giving this warning.
by DSguru2B
Mon Oct 16, 2006 12:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Log explaination
Replies: 3
Views: 616

Error Log explaination

I have this error coming up for the Jobs that I am running.
Actually this is it:

DSD_SendEvent.B:Error Starting run
Cmd = SH -c'ActivityCmd START -file MSEVENTS/20061016142140000'
Output = ERROR: Couldn't get I/O for the connection to: localhost.
ReturnCode = 1

Any ideas.
by DSguru2B
Mon Oct 16, 2006 9:48 am
Forum: Data Integration
Topic: IOD 2006 questions
Replies: 15
Views: 29361

Look at you, feeding the inner child :P
by DSguru2B
Mon Oct 16, 2006 9:28 am
Forum: Data Integration
Topic: IOD 2006 questions
Replies: 15
Views: 29361

O yea thats right. I dont know why i had Philly in my mind. Thanks bud.
by DSguru2B
Mon Oct 16, 2006 9:19 am
Forum: Data Integration
Topic: IOD 2006 questions
Replies: 15
Views: 29361

Yea. That would be nice. Man i wish i could come, i am just an hour away from Philly. Hell, 6 months ago i used to work in Philly. Err fate....
by DSguru2B
Mon Oct 16, 2006 9:17 am
Forum: Site/Forum
Topic: Vincent Hits 2000
Replies: 9
Views: 3985

No doubt. I dont know how we missed you crossing 2000. Great work Vincent. Keep up the good work.
Regards,
by DSguru2B
Mon Oct 16, 2006 8:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sybase IQ Bulk Loader
Replies: 5
Views: 2167

Smart :wink:
by DSguru2B
Mon Oct 16, 2006 8:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Opening Error
Replies: 15
Views: 5766

I know this is a far shot and might not resolve anything, but its worth a try. Your jobname, stage name and link name look really long. Try to make a copy of you job, save it as abc and put the link name as xyz. See if the job runs.
by DSguru2B
Mon Oct 16, 2006 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to know if job run from cammand prompt whether it was sc
Replies: 2
Views: 777

add in a -jobstatus before the -run.
This will return the jobstatus you see in the director.
by DSguru2B
Mon Oct 16, 2006 7:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Designing a Generic Datastage job for multiple input sources
Replies: 8
Views: 7402

Do an exact search for unix script. You will get a few examples.
Heres one
by DSguru2B
Mon Oct 16, 2006 7:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Equivalent function in Data Stage for ORACLE "like"
Replies: 3
Views: 2345

Look into the Matches operand along with the if then else statement.
So your eg will be translated as follows (cond is a stage variable)

Code: Select all

cond-----if incol.empname matches '...MITH...' then 'Y' else 'N'

constraint the output as

cond = 'Y'
by DSguru2B
Mon Oct 16, 2006 7:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Designing a Generic Datastage job for multiple input sources
Replies: 8
Views: 7402

First of all, the wait for file activity will fire as soon as the file gets created, even though the transfer is not complete. So you need to request the supplier to send a dummy file after the original file transfer is complete. Your wait for file activity should wait for that dummy file. Secondly,...