DSXchange

How to read a string byte by byte in a job For example my input string will have a value of SACHIN, I want to read S first, A second, C third so on.. I want to take S character convert into binary, take A, convert into binary and add both binary numbers and take C convert into binary add the value t...

Thanks, you sure are a premium poster

Hi Everyone,

Can anyone guide/point me to some Autosys documents or material.

Thanks

DSguru2B wrote:What do you mean by "datastage drops the file". Do you mean creates it?.

Right now, after the completion of the DS job, I am using After-job routine to drop the file on the shared server.

Hi all, In my current integration project, we all share a common file sharing server. Datstage drops the files for other system to pick the file after the required transformations and validations. The requirement is to drop the file from DataStage only if the record count is equal to or greater than...

The simplest way is to create a script file on the OS to have the logic to delete file if the file size is 0 or record count is 0 and execute this script in the after job routine.

If we try to get the metadata of the cobol copybooks using DS manager->
Import -> Table Definitions -> Cobol File Definitions
does it expect .cfd files, if yes, how to obtain the .cfd files. All I have is the copybooks in .txt format

Thanks ArndW. So, if any change happens to the copybooks on the mainframe, does that mean the metadata has to be reimported from Manager. Is there a way this can be automated, like read the copybook as a sequential file and create the metadata, so even if there is a change to the copybook, the DS jo...

Thanks ArndW, but sorry that I forgot to mention that I have tried Import -> Table Definitions -> Cobol File Definitions, but in the copybooks, there are comments for every version release/change and also the mainframe user-id's in the 72 to 80 columns numbers to identify who did the change to the c...

Hi guys, I worked with Server jobs before with source files coming out of SAP BW and also extracted files from mainframe using ftp. Now, I am on a new assignment to use the cobol copybook's structure. Can anyone tell me how to import the cobol copybooks metadata(column structure) on to the datastage...

Hi all, I have to take the back-up of all DataStage jobs from the project repository every week, this is a requirement of the client. I can export the whole project at one shot, but the client want us to export by folder. This takes up more than an hour to carefully export all the jobs every monday....

Hi all, I have a column on my file with DEC(10,2), on this columns, the value from the source system is coming as 12345.67-, means a '-'(negative) sign at the end, the target system that Datastage has to send this field is expecting the '-' sign in the beginning, like -12345.67. I tried using the Ic...

Thanks Narasimha, somehow it was defaulted to DOS style, I changed it to Unix style and it worked.

there is no quote character between columns, so I used 000

Delimiter is pipe and Quote character is 000