DSXchange

The above information is available in "dsjob -jobinfo" as well as Job Status .

DSguru2B wrote:That's one hilarious statement by kumar. Can't stop laughing...

No, its actually a hilarious delivery from Ray. Because my original post was not intentional, its typo.

You need to compromise either of the one. FTP stage is not tuned to read mainframe files. Atleast as far as I have seen, it doesn't support all the functionality available in CFF stage. So either you need to transfer the whole file into Datastage and read it using CFF and apply you rules, or you nee...

Yup... it will be certainly efficient. I had a different approach when started, but ended with this. Suresh, try using this Stage variable : vCount = Dcount(Input.Field,' ') vField2 = Field(Input.field,' ',2) Use the following derivation for each column. Firstname : Field(Input.f...

Its complaining "User name and/or password incorrect"
If its problem with client, check if you can loging into the UV account from your server.
cd `cat /.dshome`
. ./dsenv
/bin/uv
This should give you the ">" UV prompt.

Generally there wont be any problem during reading a data. Because datastage can read only to its possible extend. As you say, if it may be due to writing the data to SAP, you can do a test, by eliminating the stage and replace by an sequential file.

That may be helpful. But not to Andal after an year.

Could you locate "Line 265" in what? Was there any job no given in at any place?

What if you comment that assignment line and compile?

USS deployment in Mainframe server will improve performance.
Or ConnectDirect as mentioned in this post

Hi Loucas, Welcome to Dsxchange :D !!! Is it every time when you try to use more data, you job aborts? Try to reset you job and check if it gives any more details in "From Previous run...()" log entry. Or log int to RT_BP113 folder available in your project folder, and look at the lines around 70 to...

In transformer, Stage variable : vCount = Dcount(Input.Field,' ') Use the following derivation for each column. Firstname : Field(Input.field,' ',1) MiddleName : If vCount > 1 Then Field(Input.field,' ',2) Else '' LastName : If vCount > 1 Then Field(Input.field,' ',3)...

There are several ways, but what is the logic on the second record?
Either "donald " goes to middle name or last name??

Where ever you find "job|job_id", alias can be used, example dsjob -jobinfo can be used to get the latest info about the job using alais.

dsjob -log is used to log the information rather retrieving information.