DSXchange

Hi, I am creating an XML file from a Sequential file using XML Output Stage. In the XML file I have a requirement to repeat an element. Here is my requirement from a sample file : <structures:Instruction> - <structures:DoseAdministration> - <structures:DoseDeliveryMethod> <datatypes:Text>UNSPECIFIED...

Hi, I am using XML Output Stage to create an XML File from a Sequential File. Here is my job design : SequentialFile Stage ---> Copy Stage ---> XML Output Stage I have imported the XSD to Schema Library Manager, but I am not sure how to access that Schema Definition from XML output Stage. Meanwhile,...

Hi, I have a problem reading a cobol file, The File contains header,batch,Detail and Trailer records, The header,Batch and Deatil contains 611 Bytes Each Where as Detail has 2000 Bytes, I am using the file with the Detail copybook. With Seq File Stage, I could read the data but the data is mismatche...

I am not comparing the files in datastage, That's a huge comparision which cant be done in datastage(written a script in unix). The only thing i need is I want to see this field correctly in unix. I can see this correctly in DS, I dont know why its not happening in UNIX.

yes, u are right. I am not able to see in unix. Actually I need to compare this file with other based on this field. so i need this to be viewed correctly in unix.

yep its COMP-3. Can u please tell me how to uncompress it in Sequential File Stage

Hi- I have converted an EBCIDIC format file into ASCII format and i am able to view the file correctly in datastage, but not able to read correctly in unix. for eg: X field Decimal(13) value in datastage : 023467890601 and i am getting some 4bvbP for that. this is the only field i am not able to rea...

Looks like data is getting truncated, is there any way to handle this ?

Thanks

I found third party tool to look at BLOB data, but there is a difference from source table to target table when i used "LongVarBinary" . I am wondering is there any easy way out with BLOB data or can any one suggest any other method. I have searched the forum and looks like most of them su...

I am able to unload and load the data into target DB2 table using "LongVarBinary". But How to verify whether I am loading the correct BLOB data. I know this is out of DS .anyone please explain how do i compare BLOB data check in DB2 UDB.

Thanks

ODBC connector is only for parallel doesn't exist for Server jobs.

when you say ODBC connector, do you mean ODBC stage in datastage. Sorry I couldn't get you. Can you please eloborate a little.

What did you try? I use "VarBinary" or "LongVarBinary" with some success. ... I used "LongVarChar", but when I used "LongVarBinary" for some strange reason I am losing connection from designer while trying to view data.. So, From what I see, DS doesn't suppor...

Hi, I have to read a BLOB data from DB2 table and write to a DB2 table with out any transformations, just a direct dump. I have to do this datastage if there is a solution. Please let me know how can i do this, I tried various options provided in the forum through search. But couldn't accomplish it....

Hi all, I have an input file in which some columns occur 0 to 50 times depending on the value of another column (For example, if DOC_COUNT=3, then DOC_CD,DOC_FLG,DOC_IND,etc. will occur 3 times) and the file contains fields like CL, BR, RR, DOC_COUNT, CUST_TP, DOC_CD, DOC_FLG, DOC_IND,... Now, I hav...