I tried to use the transform 'NullToZero' in a controlling job and declared it like this (also tried some other ways):
Deffun NullToZero(A1) Calling "DSX.NULLTOZERO"
Is it possible at all to call transforms? Thanks in advance for any help!
Search found 102 matches
- Mon Feb 16, 2004 1:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Call Transforms in a controlling job
- Replies: 3
- Views: 1942
- Sun Nov 02, 2003 9:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Just for Teej
- Replies: 7
- Views: 4196
- Thu Oct 30, 2003 7:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Logging log in a file
- Replies: 3
- Views: 2559
You can do it manually in Director by chosing Project -> Print and checking the 'Print to file' option. DSGetLogSummary and DSGetLogEntry look like you could do something similar. I am furthermore quite sure that, I think it was Kim, posted code that did exactly that. If you are only interested in p...
- Thu Oct 30, 2003 5:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC list doesnt display all DSN
- Replies: 5
- Views: 2535
Girishoak, in Designer, I think, at the first glance you get only table definitions that have been saved to your repository. There is, however, an 'Import' button in Designer which will display the same DSNs as in Manager. DSNs you want to see here got to have an entry in the uvodbc.config file in t...
- Thu Oct 30, 2003 4:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Write failed for Hashed File
- Replies: 2
- Views: 2782
Another workaround is doing the lookup against a uv table. Nevertheless you would not be able to take the field in question as part of the key, because uv tables use the same hashing algorithm. But afterwards you can do the lookup using any columns. For performance reasons, you might consider to cre...
- Wed Oct 29, 2003 3:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Passing parameters dynamically to scheduled job
- Replies: 5
- Views: 2441
- Thu Oct 23, 2003 9:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic Time Stamp
- Replies: 10
- Views: 3999
- Thu Oct 23, 2003 9:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic Time Stamp
- Replies: 10
- Views: 3999
- Thu Oct 23, 2003 9:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic Time Stamp
- Replies: 10
- Views: 3999
- Thu Oct 23, 2003 8:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic Time Stamp
- Replies: 10
- Views: 3999
- Thu Oct 23, 2003 5:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: user defined SQL query
- Replies: 3
- Views: 2643
Jauthier, Looks like you can do in the columns page of the ouput tab. Introduce new column names under 'Column Names' and type the derivation under 'Derivation', e.g. ColumnName=columneight Derivation=decode(x1.datent,x2.datent,null,x2.datent) Specifying 'ZZZ xc,ZZZ x1,ZZZ x2' as Table Names on the ...
- Tue Oct 21, 2003 7:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: multiple sql in uv stage
- Replies: 3
- Views: 1998
- Tue Oct 21, 2003 1:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: multiple sql in uv stage
- Replies: 3
- Views: 1998
multiple sql in uv stage
Hello folks, I'm trying to issue multiple sql statements (as user defined sql) in a uv stage to drop and (re-)create a table and subsequently create secondary indices. I know that I can drop and create by enabling the correspondent controls. But whith user defined sql, statements separated by semico...
- Fri Oct 10, 2003 8:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UV table indices
- Replies: 2
- Views: 1472
UV table indices
Hi folks, if I create a uv-table (using a uv-stage, not a hashfile-stage), I have to specify the columns forming the primary key. Will there be a (primary) index on that primary key columns (Querying this forum gives the impression that an index will not be created)? Ray mentioned, that secondary in...
- Fri Oct 10, 2003 7:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Stopping a multiple instance job
- Replies: 8
- Views: 2405
Kim yes, I also experienced problems with the dsjob command regarding the invocations. dsjob wasn't able to return the correct list of the invocations of a job, usually you get only the job itself. Specifying an invocation as an argument to dsjob, the list will only contain that one invocation. Kind...