Search found 10 matches

by gdheatley
Mon Feb 21, 2005 5:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sourcing Data from BDAM files
Replies: 1
Views: 991

Sourcing Data from BDAM files

Has anyone had any experience using DataStage to source data from BDAM files? Any recommendations on best way to access?
by gdheatley
Mon Feb 07, 2005 11:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TeraData Fastload Connection error
Replies: 5
Views: 2940

What is the path?

Where should the PATH be set to, i.e. directory structure?
by gdheatley
Thu Dec 23, 2004 12:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Job 96 Phantom 5996
Replies: 6
Views: 3959

DataStage Job 96 Phantom 5996

DataStage Job 96 Phantom 5996
Program "DSD.StageRun": Line 755, Variable "$R61" previously undefined. Empty string used.
DataStage Phantom Finished

Any ideas? Very simple job, single transform that does call a routine and uses stage variables, but thats about it.
by gdheatley
Wed Dec 15, 2004 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Command line Job Status Options?
Replies: 4
Views: 1991

Try the -jobstatus option on dsjob -run to get a more reliable reporting of status on exit. Would this be "the best practice approach" to take then Ray rather than explicitly querying the job ? Have you ever seen any circumstances where the two have differed? Only ask as it was an Ascenti...
by gdheatley
Wed Dec 15, 2004 2:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Command line Job Status Options?
Replies: 4
Views: 1991

Command line Job Status Options?

What is the best method of getting the job status for a specific job once ran? We are executing the job using dsjob from within a script file. We have been told that the return code from the dsjob is not always accurate as to whether the job completed successfully or not. To explicitly get the job s...
by gdheatley
Thu Dec 09, 2004 2:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running jobs from Windows using 3rd party scheduler
Replies: 5
Views: 2708

Look for "dsjob" in your manuals and in this forum.. Running away from UNIX to Windose, eh?.. I usually like the other way around :D No actually looking to move from Unix to Windows. Ever tried using the SQL Bulk Loader while running DataStage on Unix? Exactly! Obviously from my message I...
by gdheatley
Thu Dec 09, 2004 12:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running jobs from Windows using 3rd party scheduler
Replies: 5
Views: 2708

Running jobs from Windows using 3rd party scheduler

Does anyone have examples of envoking DataStage jobs outside of DataStage Director on a windows environment? We are converting over from Unix to Windows platform and wish to be able to use a 3rd party enterprise scheduling tool to run our DataStage jobs. On unix it was easy as we simply called a uni...
by gdheatley
Thu May 13, 2004 9:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running Jobs from Unix script & understanding status
Replies: 2
Views: 1743

Running Jobs from Unix script & understanding status

I am envoking my datastage job using a unix shell script. Within the unix shell I am calling the data stage job using dsjob along with the required parameters. One of the parameters I am using is jobstatus. When the script runs, the data stage job is executed, and the messages I recieve back to the ...
by gdheatley
Tue Apr 27, 2004 4:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Executing a Windows Command from UNIX
Replies: 1
Views: 807

Executing a Windows Command from UNIX

Any recommendations on how to execute an application that resides on an NT server from the command line (e.g. c:\command.exe "param1") using DataStage on AIX?
by gdheatley
Thu Apr 08, 2004 1:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stage Variable Size Restrictions
Replies: 2
Views: 1608

Stage Variable Size Restrictions

Is there a size restriction on stage variables used within a Transformer Stage, i.e. number of bytes/string length?