DSXchange

Hello sundrop and welcome to DSXchange. PX jobs allow a sequential file to be used as a lookup object. If you declare your Invoice Line items file as a lookup and use your invoice number and tax/freight record column value as lookup keys you can get your status and process the other data accordingly.

If you are using version 6, then this might be the result of a programming error in DSD.StageRun. If you are certain that the only difference is in how you start the job and not the parameter values then this is the likely case and you could contact your support provider to confirm that.

Craig - yep, that is the way to do it if the formats of the header/trailer are different and you don't need the data in those rows. The header row is usually column names and will have the same number of column separators as the data, but if you have non-string columns then the text column names wil...

Are you getting that error in the log of your job or from the script? If it is in the log, does the same error occur when you manually start it in the director? Are you using the same UserId when it works and when it doesn't?

...ps -ef | grep Job name and it will show that particular JOB process ID and then put command like kill -9 PID [ Forces fully kill ] . Don't do this. It will mess up the lock tables, and unless your deadlock daemon picks it up you might have to restart DataStage. Using `kill -9' is only to be used...

Sambit - did you check those hex values on both source files (on the host and on the DataStage server) to ensure that nothing happened during FTP? I suspect that is where you are getting your problem. I just did a quick test and the EBCDIC conversion works as expected.

If the string is "language=EnglishUS; profile=8355672542; flashCookie=6; SephSessID=129.123.104.5.284841157783677969; JSESSIONID=BEE1UW1N1QOBNLAUCJBRXCQ; disable=disable; ForeseeLoyalty_MID_kINYBhFpco=65 ", then couldn't you just use In.String[INDEX(In.String,"profile=",1)+8,10]

I agree with Ray - you should use a modify stage to explicitly keep or drop the columns while leaving RCP on, or turn RCP off for your transform stage and only pass those columns down the link that you wish to keep.

What is the type and contents of the column "POLICY_EFCTV_DT" in your job?

USS stands for UNIX System Services , which lets UNIX run on an IBM Mainframe (which runs z/OS)

DataStage jobs don't "read ahead", so they wouldn't know that they have reached a trailer record unless the format were different. I recommend that you use the head and tail commands, which are available to you as you have PX under windows installed.

Does this mean that in your source system the values for this 2-character string are 0x5A 0x40? If you use a hex editor on your DataStage machine, are these also the values you have?

The ASCII value for "[" is 0x5B - right next to your value.

Kaps, login to a terminal session as dsadm (that isn't a good userid to run jobs as) and do a "truss -p 3002612" and see what that process is doing. It might be doing nothing, i.e. calls to SLEEP.

raju111.net wrote:...2)maximum how much data we can load daily?...

Depends on whether you are running DataStage on a 386sx and sharing it with a database or have 100% of a mainframe to play with.

Why is this so urgent for you?

kumardesu,

Welcome to DSXchange. Many here have used that attribute to execute filter commands. If you could explain what you would like to do and what you have tried I'm sure someone can help you.