DSXchange

We have just one record with one field. However the one field will contain comma delimited values. If the one input field contains 10 comma seperated values, then we should end up with 10 records with one field on each reacord. But we will never know how many delimited values are in the one input fi...

cool :D



Where do I put this code?

Where do I tell the code what input field to use?

The input record conatins one field and it would be a varchar 255 field. The one input field contains value1,value2,value3 etc.. we will never know ahead of time how many comma delimited values the input field contains. So each value in the field would become it's own record. value1 value2 value3 et...

One Liner - what's the one line?...if you don't mind.

Thanks everyone for your ideas. Everyone was very helpful as usual. A person in our shop is good with PEARL, and is writing a program for what we need. We try not to do things outside of DataStage, but sometimes it makes sense to take another route.

Sorry it's a comma delimted field not a comma delimited record. we won't know the number of comma seperated fields. We just know that we have a comma delimited field and each comma delimted value within the field should be parsed into it's own record. field1,field,field3 etc... will need to be field...

Horizontal Pivot didn't work because it needs multiple columns. We have one field that contains

field1,field2,field3

How can we parse this one field and get 3 records

field1
field2
field3

Hi, thanks for reading

Need to split a comma delimited record into rows.

If I have

field1,field2,field3

How can I end up with 3 records?

field1
field2
field3

We are loading and reading clob fields not blob fields, but can only assume they are the same thing. I'll tell you what we're doing; maybe it will help someone. We load XML into a CLOB field. To load the xml into a clob field we read an xml file from the server. The entire xml file is read into a fi...

The pivot stage is working for us. Wanted to post the resolution with the hopes of helping otehrs with the same question. On the "pivot properties" tabe we have "x" and y" derivations X - Field1, Field3, Field5 Y - Field2, Field4, Field6 If I read in one record Field1 Field2...

Hi, thanks for reading. Wondering if someone has tried the following with a PIVOT stage...or can help me with what I'm trying to do? Have one input record with 6 fields Field1 Field2 Field3 Field4 Field5 Field6 Need to create 3 records from one input record. Each output record will have two fields. ...

Hi, in our case even with $APT_NO_SORT_INSERTION set to FALSE we still got the error. Tried link sorts, but the error didn't go away and the osh output didn't show a sort on the reference link. The error only goes away if we do an order by in the sql or add a sort stage between the db2 udb source an...

Hi, anyone ever tried getting the last record in a surrogate key state file? I know I can use the sur key generator to view the file, but when I create a output link from the sur key gen stage I get all records in the file...only want the last value or record from the file and use it down stream. I ...

Problem solved :D - Here is the error I was getting scdSetMessageStatus,0: Fatal Error: Updatable lookup requires sorted keys. - Here is how I fixed it We had a reference link going directly into the SCD stage. We put a sort stage on the reference link after the DB2 UDB stage and before the SCD stag...

We are sorting both links into the SCD stage and have $APT_NO_SORT_INSERTION = FALSE. We were using AUTO partitioning on both links, but that also didn't work. It's as if it's ignoring all sorting attempts regardless. Any further help anyone can offer is appreciated.