Thanks ArndW
We were hoping that we could get the Job name from the Job activity stage but apperently we can't. Our plan is to use sequences so we will get the parameter values in different way, haven't figured it out yet.
Thanks again for your quick and precise answers
Regards
Peter Baun
Search found 90 matches
- Thu Feb 28, 2008 9:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Get Job Name executed from sequence
- Replies: 4
- Views: 2145
- Thu Feb 28, 2008 8:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Get Job Name executed from sequence
- Replies: 4
- Views: 2145
- Thu Feb 28, 2008 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Get Job Name executed from sequence
- Replies: 4
- Views: 2145
Get Job Name executed from sequence
Hi We have a sequence that execute a job. We want to use the job name that is being executed to make a lookup to retrieve parameter values from a file. The question is: can we get the job name that is being executed from a sequence? We have tried to name the Job Activity stage the same as the job be...
- Wed Feb 20, 2008 7:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Seq/Parameter Sets and Job
- Replies: 14
- Views: 7636
- Thu Feb 15, 2007 5:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSGetProjectInfo(DSJ.HOSTNAME) returns wrong/old servername
- Replies: 7
- Views: 3907
The last part about re-creating the project seemed to be a matter of I had not cleaned up the filesystem entirely where the old project resided. About using the operating system command hostname - the idea is perfectly good, however I don't like that there is wrong information in the UV database so ...
- Thu Feb 15, 2007 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSGetProjectInfo(DSJ.HOSTNAME) returns wrong/old servername
- Replies: 7
- Views: 3907
Hi Arnd, Thanks for your investigations. This was not really what I had planned spending a lot of time on (not blaming you of course) - and one problem often leads to another it seems like. Going forward deleting the first project gave me an error when trying to delete it. However I can't really see...
- Thu Feb 15, 2007 3:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSGetProjectInfo(DSJ.HOSTNAME) returns wrong/old servername
- Replies: 7
- Views: 3907
- Thu Feb 15, 2007 3:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSGetProjectInfo(DSJ.HOSTNAME) returns wrong/old servername
- Replies: 7
- Views: 3907
DSGetProjectInfo(DSJ.HOSTNAME) returns wrong/old servername
Hi - I have a routine in which I among other things extracts the servername - for extracting the servername I use DSGetProjectInfo(DSJ.HOSTNAME) The problem is that we changed the name of the server - but the the DSGetProjectInfo(DSJ.HOSTNAME) still returns the old server name. How do I get this to ...
- Fri Sep 01, 2006 4:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning while importing metadata from DB2
- Replies: 10
- Views: 4612
- Thu Jun 15, 2006 7:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generate timestamp only if condition met.
- Replies: 15
- Views: 9183
Hi - I assume that you fixed this but just to add some info. I am pretty sure it is a DataStage issue. Had the same problem a while ago. If you insert the value 2006-12-31-23.59.59.999999 via an sql tool it works fine but if you do it through DataStage you get an error - whenever the timestamps ends...
- Tue May 23, 2006 4:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Scheduled job that has a TimeStamp as a parameter
- Replies: 6
- Views: 3413
- Mon May 22, 2006 3:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Scheduled job that has a TimeStamp as a parameter
- Replies: 6
- Views: 3413
Jules - For testing purposes I created a very simple job with a parameter named P : Transformer --> DB2 Where I generated one row to be inserted. At runtime when it asks for the parameter value I simply enter : 2005-05-22 14:00:00. No quotes. This works fine - the entered date is inserted in the dat...
- Mon May 22, 2006 7:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Scheduled job that has a TimeStamp as a parameter
- Replies: 6
- Views: 3413
Scheduled job that has a TimeStamp as a parameter
Hi - Anyone got a solution to the following : I have a job with a parameter that is a timestamp. This timestamp is written to a DB2/AS400 database. When running this job from the director entering eg 2006-05-21 15:00:00 it works fine. Note - no quotes around this. When I schedule the same job and en...
- Sun Feb 05, 2006 10:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DB2 Date to SQL Server Date or TimeStamp
- Replies: 7
- Views: 6080
- Tue Jan 24, 2006 5:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC stage - Column name with pound sign (#) not accepted
- Replies: 17
- Views: 16111