Search found 558 matches

by ketfos
Sat Dec 17, 2011 7:34 pm
Forum: General
Topic: Differentitate Datastage 8.7 from other tools
Replies: 4
Views: 3510

Differentitate Datastage 8.7 from other tools

Hi,

With IBM releasing InfoSphere 8.7, is this the right forum to ask question.

With release of Datastage 8.7, how does it makes it different from other leaders like Informatica?

Thanks
Ketfos
by ketfos
Wed Dec 14, 2011 1:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValueConcurrent routine
Replies: 8
Views: 5181

SDKSequences hash file

KeyMgtGetNextValueConcurrent - I used this in the transformer KeyMgtGetNextValueConcurrent(1) in one job and KeyMgtGetNextValueConcurrent(2) in another job. I ran the first job for 100 rows and second job for 10 rows. It generated the key values starting from 1..100 and 1..10 in each case. I see a h...
by ketfos
Tue Dec 13, 2011 6:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValueConcurrent routine
Replies: 8
Views: 5181

Thanks. yes it has transform associated with it. That is why it is not displayed... The description of this routine is --- "Routine to generate a sequential number. The routine argument is the name associated with the sequence. The routine uses a file to store the next available number. It read...
by ketfos
Mon Dec 12, 2011 12:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValueConcurrent routine
Replies: 8
Views: 5181

KeyMgtGetNextValueConcurrent routine

Hi, Under repository, - Routines - SDK, there are routines KeyMgtGetNextValueConcurrent KeyMgtGetMaxKey KeyMgtGetMaxKeyFromODBCToUSER KeyMgtGetNextValue When I go to Transformer, Select DSROUTINES - Routines - SDK, I se only one routine KeyMgtGetMaxKeyFromODBCToUSER Can you tell me how to view other...
by ketfos
Thu Dec 08, 2011 1:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle OCI Stage not inserting null timestamp record
Replies: 2
Views: 1644

Hi
You can use @null function in the transformer for this column
It will insert value in the table for teh date field ,if it allows null values.
Ketfos
by ketfos
Thu Dec 08, 2011 1:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom 14763 Variable previously undefined. Zero length s
Replies: 9
Views: 3271

Hi Ray, This is what I did to resolve the problem. I deleted the job in the current enviornment. Imported the job from QA enviornment and exported the dsx files to the current project. Ran the job again and did not find any warning messages. Any idea why it resolved the problem. The existing code wh...
by ketfos
Wed Dec 07, 2011 4:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom 14763 Variable previously undefined. Zero length s
Replies: 9
Views: 3271

OCI Stage (Selects) -- Transformer (uses the trasnform routine) -- puts into another transformer --- does a look up against the hash file with code returned by transform -- inserts/updates into an table -- The warning messages appear at the end of the job. None of the above stage ahs any warning mes...
by ketfos
Wed Dec 07, 2011 3:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom 14763 Variable previously undefined. Zero length s
Replies: 9
Views: 3271

The message is coming at the end of the job in the following order TransInNote: DSD.StageRun Active stage finishing. DataStage Job 468 Phantom 29860 Program "DSU.TranslatePicCodeOther": Line 13, Variable previously undefined. Zero length string used. The transform DSU.TranslatePicCodeOther...
by ketfos
Wed Dec 07, 2011 10:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom 14763 Variable previously undefined. Zero length s
Replies: 9
Views: 3271

Phantom 14763 Variable previously undefined. Zero length s

Hi, I have job running fine in one enviornment. While I run the job in another enviornment with teh same data set, I am getting a message in the log with following entries. Phantom 14763 Variable previously undefined. Zero length string Line 33, Variable previously undefined. Zero length string used...
by ketfos
Tue Nov 22, 2011 6:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: project name as parameter
Replies: 1
Views: 1600

project name as parameter

How do I pass the name of the project as parameter?

I ahve before job routine where I am calling a Unix script.

e.g /ddata/wstestproj/a.sql

wstestproj is the name of the project.
I do not want to use absolute name, else script will fail when I promote to another project.

Thanks
Ketfos
by ketfos
Thu Oct 27, 2011 4:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: PXEngine and Server Directory
Replies: 4
Views: 1905

Hi Ray, Following is the directory strcture under PXEngine folder. As you mentioned earlier, it is the licens ekey which enables or disable this functionality? Is that correct? drwxr-xr-x 6 dsadm dsadm 8192 Apr 10 2009 bin -rwxr-xr-x 1 dsadm dsadm 66 Dec 3 2008 buildinfo.txt drwxr-xr-x 2 dsadm dsadm...
by ketfos
Wed Oct 26, 2011 12:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: PXEngine and Server Directory
Replies: 4
Views: 1905

PXEngine and Server Directory

Hi,
We have Datastage Server Edition 8.1 License on Unix
When I view the following folder
/opt/IBM/InformationServer,
I see two sub folders
PXEngine and Server.

What is PXEngine folder?

Ketfos
by ketfos
Sun Oct 16, 2011 2:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage 8.5 Enterprise Edition
Replies: 6
Views: 2200

Hi,

My question is not on the client for dS 8.1 and ds 8.5
My question is can we install the server for both ds8.1 (server edition) and ds 8.5 (parallel edition) on the same server.

I undersand using the mutil client we can switch the client from one version to another?

thanks
ketfos
by ketfos
Sun Oct 16, 2011 1:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage 8.5 Enterprise Edition
Replies: 6
Views: 2200

Datastage 8.5 Enterprise Edition

Hi,
We have Datastage Server Edition 8.1.
We are planning to install Datastage Enterprise edition 8.5.

Can Datastage Server Edition 8.1 and Datastage Enterprise edition 8.5 co-exist on the same Unix Server?

Thanks
Ketfos
by ketfos
Sun Oct 09, 2011 8:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage 8.5 server edition
Replies: 1
Views: 2755

datastage 8.5 server edition

Hi,
I know datastage server edition 8.5 has been there for sometime know.
We plan to migrate from server edition 8.1 to server edition 8.5.

can you guide me where I can find features of server edition 8.5?
Thanks
Ketfos