DSXchange

> We are getting an EBCDIC file in which two of the columns are Comp-3 > encoded. We convert the EBCDIC to ASCII and our transforms of simple > PICS9 columns seem to be handle correctly. It is only the Comp-3 > columns that are not. COMP-3 fields cannot be converted from EBCDIC to ASCII since they a...

"Vincent, Brad" wrote: > Unfortunately, if youre using the FTP stage to get the data from the > mainframe to DataStage, its doing a character conversion from EBCDIC > to ASCII. Various values in the Comp-3 field will come across with > different hex values than you want. Does this only affect Comp-3...

ptoneatto@diormail.com wrote: > COMP-3 is BCD (Binary Coded Decimal), not EBCDIC. > This means +123 is stored in a PIC S9(5) COMP-3 field (three bytes) > as the hexadecimal x00123C . Is it so easy or did I miss something ? > We are getting an EBCDIC file in which two of the columns are Comp-3 encode...

The best way is to create a job control routine in DataStage, and schedule that, and only that, job.

Beware dsjob; its only an example of how you might use the DataStage C API.

What version of Progress are you having? I know one ODBC for this database, its called Merant ODBC, used to be called Intersolv ODBC. ----- Original Message ----- From: "Vincent, Brad" To: "DataStage Mailing List" Sent: Thursday, August 30, 2001 3:43 AM Subject: Reading Old Progress data via DataSta...

I think the best way to do this is to do it in DataStage. From a job control program, you will have a lot more control over jobs than through a shell script. A starting point would be the automatically generated code for running jobs. When you are familiar with this, then you can enhance it as much ...

Does anyone have sample scripts to run DataStage job in unix. I want to run multiple jobs in one script, and each job is dependent on the other job. So based on the status, I want to run the other job. Is that the best way of doing this? If possible, can you e-mail me the script file, Ill really app...

Heres a challenge (literally!). An old DOS-based system here at the office is known as Progress. Its quite old. We have to import this data into our warehouse via DataStage. Documentation is ancient and the Progress database is definitely not current. Has anyone heard of this database or is anyone a...

COMP-3 is BCD (Binary Coded Decimal), not EBCDIC. This means +123 is stored in a PIC S9(5) COMP-3 field (three bytes) as the hexadecimal x00123C . Is it so easy or did I miss something ? I hope this helps. Pascal Dan Paolini on 29/08/2001 16:30:34 Please respond to datastage-users@oliver.com To: dat...

Unfortunately, if youre using the FTP stage to get the data from the mainframe to DataStage, its doing a character conversion from EBCDIC to ASCII. Various values in the Comp-3 field will come across with different hex values than you want. We bit the bullet and said, "To heck with it!" I.e., we had...

We are trying to read an EBCDIC column with a PICS9 / Comp3 format and write it to a hash file as an ASCII decimal without success. We have tried several different transformation functions, but all result in a fatal error: "Attempted WRITE with Record ID larger than table/file maximum..." We have ve...

Hi Anthony, try to check the permission of DS_LICENSE directory in $uvhome directory. Must be 777. Ive had similar problem and Ive solved in this way. Best rgds. Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: To: Sent: W...

Hi Shaun, I dont know if you mean "is there a way, other than using ClickPack, of extracting file attachments". But within ClickPack, there is a routine CPLandFile (in the Email category) which can write email enclosures to file. Heres its long description: --- Decodes MIME-encoded data which is pas...

Its important to note that sqlldr only ever passes back a successful return code. Whether the load is successful or not. I suggest you call a script that calls sqlldr and then greps the log file for errors. The script can then pass back an appropriate return code. Try something like: #!/bin/sh # Aut...

Hi All, I am aware of a DataStage Suit called ClickPack, that can perform email transformations such as extracting the textual contents of an email, but does anyone know if there is a way within DataStage, that File Attachments within an email can be extracted, and saved to a nominated location. Any...