DSXchange

Hello: Am trying to get the following query in the filter stage. (COL_NAME <> 'J' AND COL_NAME <> 'E') AND ( (COL_NAME IN ('Y', 'BRZ', 'KC', 'T', 'TK')) AND (SUBSTRING(ID,1,1) BETWEEN '0' AND '9') AND (SUBSTRING(ID,2,1) BETWEEN 'A' AND 'Z') AND (SUBSTRING(ID,12,6) NOT IN ('ZZZZZ', 'WWWWW', 'YYYYY'))...

Job5 is not able to pickup the parameters because it is not in the format that it requires. It should be pipe delimited. Gateleys provided you with the correct format. Notice that you must create and string to define all your parameter as : " Paremeter = value | parameter2 = value | paramenter...

Hello chulett Seems to be more about the fact that the 'parameter value pairs' must be pipe delimited as gateleys showed in his post... and DS_MJ is not doing that. ... The params UtilityRunJob ('JOB_5', "Par_1=" : COL_A : "Par_2=" : COL_B, 0,0) is working fine without the "...

Notice that you must create and string to define all your parameter as : " Paremeter = value | parameter2 = value | paramenter3 = value | ...| ParamenterN = ValueN" My job is failing because I am not doing the above correctly....!!! :( This is what I have done. Job 1 (Runs Fine) Db2 Table...

gateleys wrote:

DS_MJ wrote: How do I set the parameters par1 and par2...?

With your values of Col_A and Col_B. Aren't they supposed to be the param values?

gateleys

yes values of Col_A and Col_B in Job 1 are suppose to be the param values for Job5 parameters. Let me check my job ......!!!

Thanks gateleys and DSguru2B really appreciate your prompt replies. Sorry Gateleys I thought I should try it first and then reply back. But maybe I should have responded earlier .... :? I did what you said. 1. Develop a job - Job1- that read the SQL Server table and create a sequential file with two...

Hello: Would like to use the output values of one job as my parameters input values in the second job. Systems environment Ascential Datastage(7.5.1A) running on Linux R/3 PACK (5.2 unicode) running on Linux SAP R/3 4.7 unicode running on AIX (64bit) Squadron server DB2 IW running on either AIX or M...

Hi Roy:

CFF stage is used as a source stage. I want to output this to a file. CFF has no input.

Hello: Our requirement is to extract the data from SAP R/3 and create an output file having complex flat structure with Header and detial records. Would like to know what file accepts as input complex flat structure with Header and detail records? Header Record Format Description | Format| Size | Fi...

Hello:

I am glad to say that my job is working.

Thanks to all.

Yes, but did you fix your problem? Hi chulett: I apologize for replying so late.....but u must have figured out that I am facing some challanges yet. :( Plus had to finish other stuff first which I am happy to say was not a problem. My target is DB2 8.1 DataStage : 7.5.2A DS Server on : Linux I wor...

"By the way, it's hashed file, not hash file.
A hash file is a tool for reducing the size of a block of hash." - Ray Wurlod

I stand corrected, its 'Hashed file'.

Hello: I have been able to break the job into 2 jobs. in the first job i do the aggregating of the Col_X then save the max into a hash file. In the second job I lookup the hash file for the last max value. In the constraint have put if source column is > then the hash file column then go ahead and i...

Hi jzparad: Well what u say is also one of the things that I am trying out. But as kcbland pointed out (which also is one of my concerns) by doing a select max prior to running the job, as that will reliable work and one does't have to worry of synchronizing the stored max with the actual in case of...

Thank you kcbland and ray.wurlod for the suggestions.

I am still trying out your suggestions and if need further guidance will definitely touch base.

Once again thank you.

MJ