Search found 16 matches
- Mon Apr 12, 2004 4:09 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Config ODBC
- Replies: 1
- Views: 1777
Config ODBC
Hi All, I've been trying to get connection from our Unix box Tru64 to Oracle 9i Database but having trouble. DataStage version is 7.0. The error message is: OCItest..Oracle_OCI_9i_0: Error while trying to retrieve text for error ORA-12154 OCItest..Oracle_OCI_9i_0.DSLink1: DSP.Open GCI $DSP.Open erro...
- Mon Jan 27, 2003 3:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job parameter values in a job activity stage
- Replies: 5
- Views: 3037
- Mon Jan 27, 2003 3:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: joining to sequencial files
- Replies: 14
- Views: 5309
Many people mistake the merge stage as an appending stage but it's more than that. It serves many functions, Inner join, complete set, right outer join, left outer join, etc. these joins require a common key or more. The merge stage just takes two sequential files for input, and it's a little tricky...
- Thu Jan 23, 2003 12:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: joining to sequencial files
- Replies: 14
- Views: 5309
- Wed Oct 02, 2002 7:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cleanup ghost processes
- Replies: 4
- Views: 3201
Thanks a lot for making fun of my ID. :) :) There's a saying, 'If you think like one, you'll become one'. Anyways, thanks for your suggestions, Ray. The Cleanup Resources via Director tool does not clean up the defunct process but release active sessions. I tried this a while back. The LIST.READU do...
- Tue Oct 01, 2002 10:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cleanup ghost processes
- Replies: 4
- Views: 3201
Cleanup ghost processes
Thanks All in advance. I experience a problem with DataStage that is unable to clean up processes in its process table. The job was closed or got killed but the DS process table still has an entry of that process. Consequently, DS puts a lock on the job so developers can't open that job because DS u...
- Wed Aug 07, 2002 9:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Adding 1 to an year part of the date field
- Replies: 3
- Views: 1709
Hi Santosh, The problem of simple solution is 02/29/2000 + 1 = 02/29/2001 (There's no such date, just like one of the helper mentioned) you have to split the date into 3 portion, yyyy, mm, dd then use the yyyy to test for leap year by mod it by 4 and remainder is 0. If it's leap year then check the ...
- Mon Jul 29, 2002 11:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Counting records in a hash file
- Replies: 4
- Views: 2591
- Fri Jun 07, 2002 11:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Passing Parameters
- Replies: 2
- Views: 1352
- Thu May 30, 2002 3:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: View DS Job Code
- Replies: 1
- Views: 1286
View DS Job Code
I got a very strange error DataStage Job 269 Phantom 20198 Program "JOB.1949178858.DT.1256950239.TRANS1": Line 304, Improper data type. Attempting to Cleanup after ABORT raised in stage job2Tst..XfmLogics DataStage Phantom Aborting with @ABORT.CODE = 3 I'd like to view the code to see what...
- Mon May 20, 2002 4:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parameters in the constraint
- Replies: 1
- Views: 1439
Parameters in the constraint
Thank you very much in advance for your help. I'd like to use parameters in the constraint of a transformer. When I put in parameters DS doesn't like it and says "expected constraint". If I hard code then it accepts. Hardcode example, compare(field1,"Bad", "L") = 0 Para...
- Thu May 16, 2002 7:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: execute shell command
- Replies: 5
- Views: 3173
- Wed May 15, 2002 4:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: execute shell command
- Replies: 5
- Views: 3173
- Wed May 15, 2002 3:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: execute shell command
- Replies: 5
- Views: 3173
execute shell command
I tried to invoke rm on Unix from datastage to clean up temp files, but it didn't work. The temp files were created on the fly using parameters. In the job sequencer, we're able to use the execute command stage. The stage requires two things, command name, and parameter. If I want to execute rm #tem...
- Fri Feb 15, 2002 4:58 pm
- Forum: Site/Forum
- Topic: Free copy of Compile All
- Replies: 3
- Views: 4212