Search found 4992 matches

by kcbland
Fri May 14, 2004 8:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Call job in other project
Replies: 1
Views: 518

You have to use the dsjob command line program. There's no way using any API or job sequence to run a job in another project. However, dsjob command line uses a server, userid, password, and project on the command line, which should give you what you need. You'll have to write your own job control u...
by kcbland
Fri May 14, 2004 8:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help to document a project
Replies: 7
Views: 1906

MetaStage is useful, checkout the Reporting Assistant in DS Manager, search this forum for those keywords.
by kcbland
Fri May 14, 2004 9:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: date conversion
Replies: 12
Views: 4155

srimitta wrote:Hi,
i tried the below code in the constrain to change the date format
DSLink3.HIREDATE=Oconv(Iconv(DSLink3.HIREDATE,"D-YMD[4,2,2]"),"D/DMY[2,2,2]")


Just use:

Code: Select all

Oconv(Iconv(DSLink3.HIREDATE,"D-YMD[4,2,2]"),"D/DMY[2,2,2]")
by kcbland
Fri May 14, 2004 8:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.StageRun
Replies: 4
Views: 1730

Because screen output are runtime error messages and DB rejects are responses from targets.
by kcbland
Fri May 14, 2004 8:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: date conversion
Replies: 12
Views: 4155

You need quotes:

link.column[9,2]:"/":link.column[7,2]:"/":link.column[3,2]
by kcbland
Fri May 14, 2004 8:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.StageRun
Replies: 4
Views: 1730

The &PH& directory captures DS BASIC runtime error messages. If this directory is filling up then it's a sign that the job is generating zillions of error messages into the screen capture file you noticed. My suggestion is to run only a few rows thru and see the error message and correct it.
by kcbland
Thu May 13, 2004 10:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NullToValue function
Replies: 4
Views: 4169

Where/how are you using this function? Either it's not compiled or you are using inside another function without a DEFFUN statement.
by kcbland
Thu May 13, 2004 9:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NullToValue function
Replies: 4
Views: 4169

What's the error message?
by kcbland
Thu May 13, 2004 9:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running Jobs from Unix script & understanding status
Replies: 2
Views: 1263

You are not supposed to use jobstatus and run a job at the same time. Look here for an example:
http://www.dsxchange.com/viewtopic.php?t=85578
by kcbland
Thu May 13, 2004 9:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uv command invoke errors out looking for a specific module.
Replies: 7
Views: 3368

Try:

Code: Select all

$ cd `cat /.dshome`
$ . dsenv
$ ./bin/uv DEADLOCK.MENU


Else:

Code: Select all

$ cd `cat /.dshome`
$ . dsenv
$ ./bin/uvsh DEADLOCK.MENU
by kcbland
Thu May 13, 2004 8:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can you Save inside a transform
Replies: 3
Views: 710

I hear you, man.
by kcbland
Thu May 13, 2004 8:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: cache disabled
Replies: 2
Views: 1032

You don't have write caching on this file. However, I don't think this is the reason your job is aborting. It's just the last message before a catastrophic abort. These silent aborts tend to be from things like custom functions not compiled or missing, or functions blowing up.
by kcbland
Thu May 13, 2004 8:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uv command invoke errors out looking for a specific module.
Replies: 7
Views: 3368

If you do a ". ./dsenv" to source into your environment and then run bin/uvsh what measages to you get (please post exact message).

Your current error message indicates that file "libgciudt6.so" cannot be found. You need to trace this down.
by kcbland
Thu May 13, 2004 8:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: passing the value from transformer to Befor/After subroutine
Replies: 8
Views: 2761

Ray's reply a couple of posts up shows you what you need to do. COMMON variables require a custom routine to manipulate and declare COMMON variables. The same holds true for assigning to @USER? variables. Search the forum, there's tons of examples posted.
by kcbland
Thu May 13, 2004 8:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can you Save inside a transform
Replies: 3
Views: 710

Because you could cancel out of your changes to the transformer. Once you save the job, you would lose the cancel option.