Search found 133 matches

by Luk
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

one more quick question:

is there (in DS) possibility to apply to job parameter value from (for example) file??
by Luk
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

thanks!!
now I know taht job parameter must be between '#' characters
by Luk
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...
by Luk
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...
by Luk
Thu Apr 07, 2005 7:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValue
Replies: 3
Views: 1083

thanks culett!!

I'm going to Manager write now :) and I will read and test it!
by Luk
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)...
by Luk
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...
by Luk
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

changing terminal type is not working like that, after I have changed terminal type (one from list) , the "+" mark is still situaited next to default terminal type. But never mind, I will try to "play" with it more. This is not an urgent or important problem, I was only curious w...
by Luk
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
by Luk
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

Thanks!!

ArndW, could you tell me what command with what parameters sets terminal type (I couldn't change default type by SET.TERM.TYPE) and what is the proper terminal type for ssh connection (PUTTY) ??

Regards
by Luk
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 ...
by Luk
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

Thanks ArndW!

I suspect that that way it will work, when I will reinstal DS with new serial number. I was only curious if someone try it erlier and I wanted to ensure that it is possible to have access to old projects during reinstallation procedure.
by Luk
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

You should be able to go into your administrator and enter the new license details and reactivate your DS system. what if you stop DS engine using "uv -admin -stop" after license expiration ?? Can you run administrator then ?? I can't!! I'm getting error message like this: Sorry, this ver...
by Luk
Thu Mar 24, 2005 5:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: row number limitation
Replies: 2
Views: 1211

thanks again garthmac !!

it works perfect :!: :!: :!:
by Luk
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 :lol:
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