DSXchange

ArndW wrote:Try converting all of your COMP fields to correctly sized PIC(x) columns and read the data, see if the contents of COMPANY and DIVISION remain correct - in that case you have correct length. Then chan ...

It is showing still the same garbge......

ArndW wrote:Odd - co you have one import of the copybook into your DataStage metadata and are inserting that definition into both jobs? ...

No, i have deleted the Server job and i tried the same definition with Parallel job.....

The PIC X column, ARS-NAME, shouldn't cause problems. If it does, it probably means that your record length is off and binary information is being parsed as part of that string, most likely your definition is shorter than the real data and the contents of the subsequent COMP-3 field are coming into...

Please post your COMPLETE FILE DEFINITION of the SOURCE. I recently came across COMP fields in Mainframe and have solved the issue using the server job. Here is my complete file defintion.... 01 ARFSLSMN-RECORD. 02 ARFSLSMN-KEY. 03 ARS-COMPANY PIC X(3). 03 ARS-DIVISION PIC 9(4) COMP-3. 03 ARS-SLSMN...

DSguru2B wrote:Is TIMESTAMP even present in parallel jobs? I am not near a DS machine so cannot verify.
For the date to timestamp conversion, refer here.

sorry It is not there in parallel i cheked just now...I was on server job at that time....Sorry about that yes you can use DateToTimestamp.....

Umberto wrote:Hi

May anybody indicates to me how to view the objects generated by DataStage after the compilation of a Job PX???

Thank you very much in advance

Umberto

can you elaborate your question?

Hi All, My source is a flat file and this file is loaded into a table.A Date column in a file has Datatype as Date and the corresponding field Datatype in Table is a Timestamp . If I am following to the structure as it is ,the job gives me compilation error like invalid conversion from Date to Time...

dsadm wrote:Hi,

Just had the same probleme.
You just need to specify the row commit interval within db2Plugin

If you have the update action as insert or update the rown commit size should be 1..If you do that the error will go off....

RK - I'll trade you answers. If you can tell me what the blinking red light on my car dashboard (the one in the top left corner) means and how to fix it, I'll help you with the CFF issue. p.s. In case the post above was too subtle - please add some more information to your problem description; i.e....

I tried but i am getting the following error DSR.MetaGeta(GET.TABLES)(SQLConnect('DB_AS400','user')): BCI Error: SQLSTATE=S1000,CODE=7742,[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]7742 Thanks... On your .odbc.ini pls check what is the driver that DB2 wire protocol is u...

Krish, Yes..thats under project directory and also there are entries for sql server. No problems when i use sal server odbc dsn.. My suspension is something missing in my .odbc.ini entry for db2 dsn.. Thanks for your response.. AS it is in AS400 give on the location as OS/390 and AS/400 give it a t...

Krish, Yes..thats under project directory and also there are entries for sql server. No problems when i use sal server odbc dsn.. My suspension is something missing in my .odbc.ini entry for db2 dsn.. Thanks for your response.. In the IP address try giving the fullname like testserver.XXXXX.com/net...

edward_m wrote:

ray.wurlod wrote:You also need an entry in the uvodbc.config file for your DSN. ...

Yes..i defined the following entry in uvodbc.config file

<DB_AS400>
DBMS_TYPE = ODBC

Could you please let me know what else i am missing..

Did you mention in your project Directory....

Hi, I have weired results on the CFF stage with server and parallel jobs..I used the CFF stage in Parallel job it gives right result.when i was trying to laod the same file using server in the CFF stage i see some junk data on the particular field in in some columns there are unmatched data between ...

g_rkrish wrote:

DSguru2B wrote:Did you add the entry in the uvodbc.config file in the project directory?

Yest i did....The DSN created for DB2 is working but for the SQL server is throwing up the error

there was some problem with the connection ..I fixed it works fine thaks for the help.......