Search found 35 matches
- Wed Feb 18, 2009 7:50 am
- Forum: General
- Topic: how could i append "Date" to sequential file name
- Replies: 13
- Views: 10145
But carries baggage of it's own which may be too heavy. Like, an After routine is already defined for the job or such a simple task as renaming a file seems overly complicated to do it in two places, one fairly hidden in the GUI. I like using a DS Macro for this; #DSJobStartDate#.csv Everything has...
- Fri May 30, 2008 10:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance improvement for Lookup
- Replies: 1
- Views: 1323
Performance improvement for Lookup
Hi All, I have a set of 10 jobs which are called by a sequence one after the other. The last 3 jobs are taking almost 75% of the total time required to run the sequence. This is because these jobs does the lookup with db2 tables which are huge in volume. To improve the performance of the sequence, I...
- Thu May 01, 2008 3:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup file sets ??????
- Replies: 10
- Views: 3885
- Mon Apr 28, 2008 1:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing a string parameter with ' characters
- Replies: 2
- Views: 3823
Thank you very much OddJob. Your solution worked for me. But later I found that I got messed up because the $PROJDEF variable assigning the default value which was wrong. In my case the starting and ending single quotes are given in the query itself as you can see select name, id from emp where name...
- Thu Mar 27, 2008 11:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to Pass Special Characters as parameters
- Replies: 4
- Views: 3750
No special characters are allowed. If you need the special characters in a Transformer stage, consider using a Stage Variable's initialize capability to call a Function. Have a custom DS Function fetch the value from either: 1. the environment, 2. reading a file. Hi kcbland, If i am to try your fir...
- Wed Mar 26, 2008 5:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to Pass Special Characters as parameters
- Replies: 4
- Views: 3750
How to Pass Special Characters as parameters
Hi All,
I need to pass a special character (like char(128),char(129)....) as a parameter to my job. How do i do it?
I tried passing the hex values as \x80 OR 0x80 OR &H80
also the dec values as 128 OR \128
None of these works.
I need to pass a special character (like char(128),char(129)....) as a parameter to my job. How do i do it?
I tried passing the hex values as \x80 OR 0x80 OR &H80
also the dec values as 128 OR \128
None of these works.
- Tue Feb 19, 2008 4:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Order by Clause in DB2 Enterprise stage
- Replies: 3
- Views: 2436
- Thu Feb 14, 2008 2:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Order by Clause in DB2 Enterprise stage
- Replies: 3
- Views: 2436
Order by Clause in DB2 Enterprise stage
Hi All, I am reading a db2 table in Datastage with DB2 Enterprise stage and using the Read Method = Table. I want to give a order by clause to the columns selected using the select list property. Where do I specify this? I tried to give it in the where clause property though I don't have a where cla...
- Sat May 26, 2007 4:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: BASIC Transformer Error
- Replies: 4
- Views: 2641
Hi, Try setting your Basic Transformer to run sequentially by setting the Execution mode to Sequential in the properties>>stage>>advanced tab IHTH (I Hope This Helps), ... Hi All, Is this problem solved? My job design is also the same as explained in the begining of this thread. I am getting the fo...
- Tue Jun 27, 2006 7:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Capture the error records
- Replies: 5
- Views: 2108
- Tue Jun 27, 2006 3:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Capture the error records
- Replies: 5
- Views: 2108
In the transformer prior to the DB2 API stage, on the rejectred link, in the constraints, use LinkVariable --> Outputs --> (DB2Link) REJECTED. This is applicable only for Server jobs. But what about in PX? In PX we cannot get the (DB2Link) REJECTED option. So then how will we capture the rejected r...
- Wed May 31, 2006 1:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How can I do a dynamic select?
- Replies: 13
- Views: 9182
well you will need to get that value from a dataset and put it in a sequential file. As per the routine, you can do that in a sequence job. In the properties of job activity, click on the Value Expression of the Parameter ValRange and click on Routine and there you can call your routine. The output...
- Wed May 31, 2006 12:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How can I do a dynamic select?
- Replies: 13
- Views: 9182
Sorry about that. Since tiagogen has already done with (i guess :roll: ) I thought we will continue in the same thread as it will be easier to communicate the idea. Yes but then the forum is totaly different... :( My parameterfile.txt is not a sequential file but it is a data set. So the code $JOB_P...
- Wed May 31, 2006 12:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How can I do a dynamic select?
- Replies: 13
- Views: 9182
Sorry about that. Since tiagogen has already done with (i guess :roll: ) I thought we will continue in the same thread as it will be easier to communicate the idea. Yes but then the forum is totaly different... :( My parameterfile.txt is not a sequential file but it is a data set. So the code $JOB_P...
- Wed May 31, 2006 11:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How can I do a dynamic select?
- Replies: 13
- Views: 9182