Thanks for all your help. It seems to be just an issue that I have. What I have found also works is to place portions of the statement in yet another stage variable and evaluate it there.
Thanks.
Search found 30 matches
- Mon Apr 11, 2005 8:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: IF statements and order
- Replies: 5
- Views: 2550
- Thu Apr 07, 2005 9:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: IF statements and order
- Replies: 5
- Views: 2550
IF statements and order
I am just wondering if anyone has ever had an issue with the IF statement and the ordering of the clauses within the IF statement. On several occassions, I have tried to debug some of my jobs and the problem ended up being the order of the comparisons I was making in an IF statement. For example If ...
- Fri Feb 04, 2005 9:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inconsistent run times
- Replies: 4
- Views: 2157
Thanks for all your suggestions. I will try them out and see if I can isolate the problem. I do know that the database tables being locked is not the problem as I am the only one accessing the tables and I have checked with the DBA a couple of times and the process is not being blocked so it has to ...
- Thu Feb 03, 2005 4:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inconsistent run times
- Replies: 4
- Views: 2157
Inconsistent run times
Hi, I have a datastage job that uses an OLEDB connection to a database, runs a script in the BEFORE SQL and then splits the data into one of three text files located on the network. The transform for this job is simple as it only checks the value of a column to separate the data into the files. I am...
- Thu Jan 06, 2005 3:59 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Return Values from Routine Activity
- Replies: 2
- Views: 1974
- Thu Jan 06, 2005 3:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Return Values from Routine Activity
- Replies: 2
- Views: 1974
Return Values from Routine Activity
Hi, I am attempting to call a routine using a Routine Activity in a sequence. Based on what the return value is I decide on which path to follow. However, although the routine is being called, it always returns the error DW03100sLoadBackOut3..JobControl (@routCheckinsCertStaffRptAssoc): Routine DSU....
- Tue Nov 23, 2004 2:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Sequences and String Parameter
- Replies: 3
- Views: 1784
- Tue Nov 23, 2004 2:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Sequences and String Parameter
- Replies: 3
- Views: 1784
Job Sequences and String Parameter
Hi, I've created a set of jobs which require a date and time parameter. In the job, I've created a string parameter "extract_start_dt". In the job, if I set this parameter to "2004-10-01 00:00:01.000", the job will run okay. I've also generated a sequence to run all these jobs ag...
- Tue Aug 24, 2004 1:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Conversion
- Replies: 2
- Views: 1255
- Tue Aug 24, 2004 12:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Conversion
- Replies: 2
- Views: 1255
Date Conversion
I have a job that reads in a timestamp of 1900-01-01 00:00:00.000 and I want to read it out to a sequential file as 1900-01-01 00:00:00. The problem is DataStage for some reason is not reading the 1900-01-01 properly. The other date statements will convert properly but not this one. The statement we...
- Tue Aug 10, 2004 8:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OLEDB stage
- Replies: 4
- Views: 2184
I have done this before where the temp table is created and populated in the before SQL then read in the same stage's user defined SQL. I think that this is about the only way you could use the temp table since (from what I can tell) each OLEDB stage in the job has it own OLEDB session. I never tho...
- Tue Aug 10, 2004 7:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OLEDB stage
- Replies: 4
- Views: 2184
- Mon Aug 09, 2004 11:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OLEDB stage
- Replies: 4
- Views: 2184
OLEDB stage
Hi,
I am wondering if it is possible to use an OLEDB stage (connecting to SQL server) to create temp. tables on the fly and then read in the results of the temp. table to DataStage for further processing.
Thanks.
I am wondering if it is possible to use an OLEDB stage (connecting to SQL server) to create temp. tables on the fly and then read in the results of the temp. table to DataStage for further processing.
Thanks.
- Wed May 12, 2004 10:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sharing Secured Routines between projects
- Replies: 6
- Views: 2592
- Mon May 10, 2004 1:16 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sharing Secured Routines between projects
- Replies: 6
- Views: 2592