DSXchange

Use a before job subroutine and concatenate all the 4 files into one, and use the this file as an input to the job.


In the after job subroutine delete the data set the is temporarily created.


Even one data set does not exist this will not create any prob.

How are you passing the values to the job?

nkln@you

Can you please tell us what is the Data Type you have been using for the derivation(Target).

If you have you the appropriate data type then you should get the -ve value

I believe you are using an inappropriate data type so the solution is becoming as 0 (no precision added )

Sri, There are two methods of creating the Header and trailer to a file. 1) Manual 2) Automated In manual process you have to manually amend the header and trailer to the file. In an automated system send a file as in input to the system, the out come of that would be an header and trailer added to ...

Let us know how you are scheduling you jobs.


If you are running the job using the control M script then use a param file and pass the user name as a parameter with in file and use the same in your processing.

The error messages clearly says that the job is failing with time out error. With in the propertys tab of sequence there will be parameter called as wait for job, by default it would be 10 sec(not so sure but....) just change it to a higher value that should help you to solve the issue. Do let me kn...

if that is the case, make sure you have given these 5 parameters correctly Client Instance name <DB2 iinstance name> Database Name <DB2 server name> Password <password> server <datastage server name> user <Datastage user name> please note if there is any difference in user name and password for conn...

It is evident with the error messages that the password is wrong. following could be some of the scenarios for the same You have given the correct password but for a different server name. or correct server name but the wrong password. Please make sure that you are using both appropriate once.

Make use of the sleep and wait command from the Unix O/S to wait and poll for the jobs

Just write a small script to do so.....


awk -F"|" '$1/Property/ {print $1, $2}' File_Name > OutputFilename

Should help you...

do let me know if you have any prob.....with this...

Just to give you some Idea, Here are some good links which I have got during my search.... hope will help you as well http://mercury.chem.pitt.edu/~sasha/LinuxFocus/English/September2001/article216.shtml http://www.grymoire.com/Unix/Awk.html http://infohost.nmt.edu/tcc/help/unix/unix_cmd.html etc.....

Thanks for sharing your idea

bvishwanathr


Though it is NOT a very good solution but it worked for us.

Do give a try on this

Just rename the job compile and run it that should solve your problem, do let us know if it really works in you case as well.

Ram,

Can you share, with us the logic, you have been using to find if the file exist or not with in the unix script. Hope that should help us when such a requirement come up.

Thanks in advance.

As per your question about the limit of varchar is concern it can handle up to 32,672 characters in length. Do check what you have given in the target. Also check what is the display value you have given in the metadata of the source. These two check should help you to resolve the prob. Do let us kn...