DSXchange

Hi All, I have a need to delete the records of a certain table at the end of the sequence . I have created a job for this where i am using a transformer(input) and a oracle stage(output) where the transformer only has output rows which is nothing but the columns of the particular table i'm trying to...

Hi All,

I have this senario where i need to convert a filed(10) of type double to filed(10) of type integer . i 'm trying to use a modify stage for it . can modify stage support this if so wht is the function to convert double to integer

Thanks

Hi All, I have this job where i need to make the transformer wait untill a certain function has completed processing. Well i have the data where i'm hash partitioning it based col1 .i need to pass this data to the o/p file . but the issue is here when the data has passed in all the values of one gro...

I am loading huge data(400,000) into flat file.
One of the row has a column decimal overflow problem.
Need help ,how to handle this ..


Thanks in advance
beeram

I am reading Ascential manuals ,it is mentioned like lookup file set stage and file set stage will crete file with extension .fs.
What is the difference between two stages?

thanks in advance
Beeram

Thanks Bland, I wrote this code in job control within the same job. and i declared a parameter ScrOutput in job parameters with some default value then i called ScrOutput parameter into Transformer. This not working properly .when i ran it is taking time ,never end the job unless i kill that one. hj...

Thanks bland, i am almost done but still i have doubt on passing value : Below is my code : hjob1=DSAttachJob("demojob2",DSJ.ERRFATAL) IF NOT(hjob1) then CALL DSlogFatal("Job Failed:demojob2","JOB ABORTED") END Unixcmd="/fdev/users/10001/Proc.shl" CALL DSExecu...

I need to use query output.
I wrote job control but not able to pass to job parameter.

Thanks Bland,

as per your guidelines i can call in stage variable but also i need to use that value in another stage(Not in transformer) as job parameter.



Thanks
Beeram

Hi,

I have a db2 procedure in my UNIX script,when i execute it returns a value,i need to pass that value into (Job Parameter) to use in Transformer.

I tried with execSH and i passed path and file name as Input Value.
Then how to pass that output to job parameter?


Thanks
Beeram

Hi , I wrote sample C++ routine , compiled with CC command and calling into Transformer. When i ran the job getting following error. I am taking as external function(type) and object type as Object(Not library).Am i following in the correct way?Need help XFMR_Matched_Trade: Failed to load the librar...

My DataStage server is on NT and Files are on UNIX Box,
So these files are external sources to Datastage Server.

In this situation can i pass UNIX Command output to job parameter?




Thanks
Beeram

Hi, My job has to run everyday to extract data from a Flat File(files will be on the UNIX box) . There should be multiple files,but my sequentila file has to pick latest one. Files are named with some text + timestamp. All the files will have name and will be differentiated with timestamp. EX: 1) Wa...

Hi,

How to pass UNIX Shell script return value to Job Control Job Parameter.


Thanks
VBeeram

Hi Ray, As you said i already did ,im able to take max value(Latest date and Max sequence_No) from Hash file, but im not able to pass these columns into Transformer,since these are individual columns. Since im using Sever job i cannot use Column Generator Stage. ODBC(SOurce)--------->TRNSFORMER-----...