DSXchange

havent gotten any resumes so far. any interested parties?

Hi,

I get this warning with three of my lookups

Input Dataset 0 has partitioning other than Entire specified; disabling memory sharing.

Previous posts could not help it out.
Even when I changed the partitioning to Entire I got the same warning again.How can I solve this issue?

Hi, Thanks for the replies... I have tried the posts but they were not much helpful. I have the OS env variables INCLUDE and LIB pointing to the corresponding folders of the SDK. And I have not changed the default settings in the DS administrator for the compiler environment variables. Am I missing ...

Hi,

Sorry to Hijack this post.......
I am getting the same error when I try to install DS Server on a 32 bit Windows 2003 machine..

Please help me!

Thank you!

the problem was actually table name not being specified

this issue is resolved; problem was in 7.5.2 sql used to be where num=:num in 8.x it needs to be ?

i am getting the following error;DataStage Job 138 Phantom 9612 Program "DSP.Open": Line 122, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage J07_INSERT_INTO_MDM_NODE_M..Copy_of_DUAL DataStage Phantom Aborting with @ABORT.CODE = 3 All...

i have a requirement where in i need to get the sequence numbers and use it for various purposes, when i use the lookup with oracle enterprise with sparse, its returning NULL. my sql is like this select mdm_seq.nextval as TASKID, '1' as dummy from DUAL; i also use dummy variable in the source file a...

I have a stored proc that we call for every row and the procedure writes to staging table for all the matching records. One particular row has about 365k matching records and its taking 40 min to write to staging table, the problem we have is we dont get any response back after some time. its workin...

we are receiving international data, and i want to know if dataset handles it or not, if yes what do we need to do so DS handles it.

my requirement is as follows, i have an input file, and on one of the fields , i need to do a look up, which will return 3 rows always, with 1 column ineach row, now i need to add these 3 vaules from 3 rows into an output file into 3 diff column on the same row. we are using lookup stage in parallel...

my understanding is that all these stages will tell us if keys or values changed. if i want to know what coulmns got changed with in value columns, i didnt find any option.

i have a need to compare 2 files and 2 specific columns in it.. i have a need to know what column got changed. is there anyway to find out what column got changed. i dont see anywhere in change captur /compare/difference stages that tells us.

whats this toolkit. does it come with Datastage?

i need to run an unix script from an etl server thats on windows. how do I do that. pl help.