DSXchange

Hi
I thought INLIST is an option.
Please let me know if there is any workaround
Thanks in advance
Raghu

Hi SQL i am reading from DB2 is Select Code, Color_Desc, ColorPattarn from DW.CODECOLORS where Color_Desc IN (#ColorParams.ColorCodes#) with ur; Parameter values ColorParams.ColorCodes = 'RED','BULE','YELLOW'. number of values seperated by ',' will be changing from job to job I can view data with th...

ArndW wrote:If your values are in a string and formatted correctly for sql, just insert them into your custom SQL as a single value. ...

Tried the same .
I can see the viewdata but the job is failing the same to write to a file.

Thanks for your help.
I appriciate any more ideas.

Thanks
Raghu

Hi I need help with INLIST function. I searched in the forum but no luck. It looks like it used to be there previously I need to pass the multiple valued to a " select .... from ... IN ( val1,val2,val3,....,...,...) " But i will get all values in one parameter as input. the list of parms a...

Hi, in my system we installed windows and Dastage px .To run the transformer stage is it mandatory to install dotnet framework or if i install vc compliler will it work. If you are installing PX on XP pro then you need 7.5x2 version of datastage and 2003 C++ compiler. First install c++ ccompiler an...

Hi Rumu,
No Conversion program to move the data from DB2 to SQL server. In datastage you will load both DB2 metadata and Sqlserver metadata. You may need to code some fields like date conversions.

HTH
Raghu Mule

With ArchAdmin command you can remove the datasets that were built in 7.5 and i am not sure about 8 and above
HTH
Raghu Mule

Default max size is 2G . your admin can make it what ever you want on a partition

or they can create a file on multiple nodes that you can use for placing huge volume of data

HTH
Raghu M

Hi There is no such rule to seperate it, But if a process is taking more time to run more number of records like millions then we generally suggest to go parallel, Going from server to parallel is not an upgrade we need to rewrite the process again. If you are using heavy loads we suggest to go para...

Hi Contact your Unix admin on the file size . they can increase the limit on the file system that you are using. HTH Raghu M Hi, I developed a parallel job which extracted a huge amount of data and wrote them into a sequence file. But the file was so huge that it was beyond the unix file limit(2G). ...

Hi

Add File watcher in the sequance between each job
or
After FTp1 - Ftp2 and Ftp3

Wait for file1- job1
Wait for file2- job2
Wait for file3 - job3

HTH
Raghu M

rajkraj wrote:Hi,
if i get only File 1 FTP'd successfully than i run only Job1 and not run the other 2 jobs Job2 and Job3
Thanks.

Check the Drive mapping 'I:' on the Datastage Server box. Map the drive as that is there in your box and see the user that you are running have the permissions to that location and See the dos commands path is set correctly on your PATH variable HTH Raghu M I have a job:Pandora_Flexcab_BTP While i a...

You can change the post title to Multiple instance Check the job properties for the multiple instances check bos. If that is On then job can run multiple instances. Say you have a job that run with one set of data. split that data into multiple files and give each file as source to each job . you ca...

Hi Raj, As i unserstand your process you are running DB scripts . You can change them to Stored procs and call from datastage if you want. I have seen some clients do that insted of calling them seperately. But the error capturing is little more complicated than we expect. So talk to your DBA and se...

hi sudha, please check the Date farmat conversion is proper before moving. Replace the dummy date when the field input is blank. HTH Thanks Raghu Hi, I am getting the following error while loading the data into Oracle. Oracle_Enterprise_29: When checking operator: When validating export schema: At f...