one more quick question:
is there (in DS) possibility to apply to job parameter value from (for example) file??
Search found 133 matches
- Mon Apr 11, 2005 6:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: select only new records (ODBC stage)
- Replies: 6
- Views: 1293
- Mon Apr 11, 2005 6:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: select only new records (ODBC stage)
- Replies: 6
- Views: 1293
- Mon Apr 11, 2005 6:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: select only new records (ODBC stage)
- Replies: 6
- Views: 1293
You can use job parameters for constants in the WHERE clause of the SELECT statement. Fill in the WHERE clause, without the word WHERE, on the Selection tab of the ODBC stage Output links properties. OK ray, but how (in what form) must I write job parameter ?? for example : I have parameter xxx - w...
- Mon Apr 11, 2005 5:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: select only new records (ODBC stage)
- Replies: 6
- Views: 1293
select only new records (ODBC stage)
Hi all! I must select from sources only new records. In my source I have timestamps (MSSQL server binary8 timestamps). I'm using job parameter telling me what is the last number of previously loaded record and in transformer I'm rejecting old ones. I'm wondering - is there some way to use this jobpa...
- Thu Apr 07, 2005 7:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: KeyMgtGetNextValue
- Replies: 3
- Views: 1083
- Thu Apr 07, 2005 3:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NULL in fact table as FK or ....
- Replies: 2
- Views: 1512
NULL in fact table as FK or ....
Hi! This is not strictly DS question but maybe someone had similar situation. Let's say we have two dimensions: customer and vendor, and one fact table with columns: customer_id, vendor_id and value. In one row in fact table we can have reference to customer dim or vendor dim (never to both of them)...
- Thu Apr 07, 2005 2:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: KeyMgtGetNextValue
- Replies: 3
- Views: 1083
KeyMgtGetNextValue
Hi! I have two simple (i think) questions. 1) All key sequences are stored in SDKSequences hash file. Is there some command to reset one seq or all seq in one time?? Is the only way to reset seq putting new start seq value to SDK file using hash Stage? 2) What is the difference between KeyMgtGetNext...
- Wed Apr 06, 2005 8:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Command Language (DS shell)
- Replies: 8
- Views: 5301
- Wed Apr 06, 2005 6:21 am
- Forum: Site/Forum
- Topic: Forum time GMT +1
- Replies: 10
- Views: 7660
Forum time GMT +1
Hi!
Is the time displaing on forum site correct?? I live on GMT +1 time zone and here it is 14:23 and in forum there is 13:24!!
Maybe you don't remember about time change to summer time??
:D :D :D :D
regards
Is the time displaing on forum site correct?? I live on GMT +1 time zone and here it is 14:23 and in forum there is 13:24!!
Maybe you don't remember about time change to summer time??
:D :D :D :D
regards
- Wed Apr 06, 2005 6:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Command Language (DS shell)
- Replies: 8
- Views: 5301
- Wed Apr 06, 2005 4:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Command Language (DS shell)
- Replies: 8
- Views: 5301
Datastage Command Language (DS shell)
Hi all! Where can I find list of avalible commands in DS shell (./dssh in Unix) ? When I run command HELP uder DS shell on UNIX (I'm using ssh connection to sewrver), display format of help is horrible (some stupid colors and characters) - I can't read anything!! Amd HELP command is unavalible from ...
- Thu Mar 31, 2005 6:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Help!! I've lost my poroject
- Replies: 8
- Views: 4187
- Thu Mar 31, 2005 6:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Help!! I've lost my poroject
- Replies: 8
- Views: 4187
- Thu Mar 24, 2005 5:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: row number limitation
- Replies: 2
- Views: 1211
- Thu Mar 24, 2005 5:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: row number limitation
- Replies: 2
- Views: 1211
row number limitation
Hi!
I have great day for posting today
I want to run job without row limitation but also I want to run 1 stage (transformer) wchich is in that job with row limit (i.e. 5 rows only).
Is it possible in DS??
Regards
I have great day for posting today
![Laughing :lol:](./images/smilies/icon_lol.gif)
I want to run job without row limitation but also I want to run 1 stage (transformer) wchich is in that job with row limit (i.e. 5 rows only).
Is it possible in DS??
Regards