DSXchange

If you do search for range lookups, you will find many posts on this as it is discussed several times. You will get the solution in search itself

In addition to the LIBPATH, you also have to set the APT_CONFIG_FILE env variable.

Have you tried recomiling the job which is failing and then running it?

For operator, job run is allowed. I think job design can not be seen for this role.

If you want access to job design, assign Developer role.

You can use the command mentioned in Kenneth's reply - dsjob. In your Datastage home directory, go to bin and there you will find the dsjob command. There are lots of options and you can use dsjob -report in it as follows: dsjob -report <Project> <Jobname> It also has diff format of output. Check it...

can not legally be changed thereafter Ray, just a bit curious to know - does this mean there is a illegal way to do this? Search the forum for the setting job params and you find the way to set params in before job routines. Use the job parameters and set their values in before job as suggested by ...

May be some can throw light on it - To capture the rejected codes or error numbers using such link variables, should the commit freq for target RDBMS stage be set to 1?
Or will it work with some other value as well?

These are called as Link variable and when used they give you the status or errorcode for link for which it is called. Consider a job seq file-->transformer--->DB2 |--->Seq file Here in my DB2 I have set the commit as 1 and in the link ordering it is first link to be executed. So for each incoming r...

Is your seq file stage properties are set to read complete report of one job as single row or are you reading each line of the report from the sequential file? If you are reading whole report from the sequential file as single row with single column then, you will have to use substring and index fun...

This error is shown when the target decimal datatype has length less than string. E.g. if your string is 12345 having 5 chars and you are trying to store it in the decimal field with less than 5 length.

Whats the source and target col datatypes?

When we have a output link from XML output stage, where we define a single column having whole XML data, still it is writing the data in some temp file.

So the double disk I/O is unavoidable in this case as Craig has said.

could you explain further? ie: what is JP_DBASE_PASS? also, are you saying i should have a DS routine called 'rEncryptString' or 'EncryptString' somewhere in my installation? Mentioned JP_DBASE_PASS is the name of job parameter and is just as an example. In my job this param is defined as encrypted...

To avoid the disk i/o, can it be done in the job itself? To the XML output stage, we can add one output link which will have Xpath which will accomodate all the XML and then use transformer to do the formating. Once this is done, we can write it to disk using some seq file stage. I will try this out...

Hey you have not posted the XPaths used in your job.

Nways, instead of parsing all the columns from the XML try n parse single or less number of cols wherever you have problem.
So say first only try n extract JobName - the XPath for it should be /Job/@Name.

Filename1 = Field(InputArg,"~",1) Filename2 = Field(InputArg,"~",2) Filename1A = '/In/first_`date +%Y%m%d`.TXT' Filename2A = '/Out/second_`date +%Y%m%d`.TXT' If ErrorCode = 0 Then Command1 = 'cp :"filename1":' ':"filename1A"' Command2 = 'cp :"filename2&q...