DSXchange

Great! :D

Please mark the topic as 'Resolved' when you get a chance.

Use two parameters, one for the folder and another for the filename.

Thanks for posting that. Always best to give real examples over made up ones.

If you could also mark the post as 'Resolved' we'd appreciate that, too.

No problem. Care to share so if someone else comes looking with a similar problem they know what the fix is?

And what do the contents of your file look like? Without examples, how can we tell why you don't get a result from your grep? I'd also be curious what O/S and field delimiter is involved.

Or just have an opinion in general on using third-part tools with DataStage to generate large quantities of XML? I'm looking to see if there are any options to the XML Output stage when 12 to 18 million records need to be converted to XML. I get spammed quite a bit for both their XQuery and now XML ...

Suggest you explain what "did not work" about it. That's exactly what that option is for.

Interesting. Probably could have just rebuilt the project indexes, but you found a solution. Could you please mark the post as resolved?

LF means Line Feed, also known as a CHAR(10). You'd see all this on any ASCII chart. It is the character that UNIX uses as the 'Record Terminator'. You would need to determine if that, indeed, is the case. And if so, if they are appropriate to keep as 'data' or should be removed. Keeping them is ea...

Not without more information. What are the nature of your duplicates? What have you tried so far? Two generic answers: 1) A hashed file, by it's "destructive overwrite" nature, can "remove duplicates" from a data source. Define the unique keys needed, write all, read back - no duplicates. Don't forg...

If you upgrade to 7.5.x you'll have an actual honest-to-goodness Stored Procedure stage and your options would increase. However, your version has only ODBC for this work. Do you not have a Transformer before the ODBC stage? There you can define your three fields whose derivations are the values you...

When i tried to log into administrator and choose the projects, when the properties button is pressed, then its giving the Runtime error '6' Is this just an issue for you or does everyone get this error? You'll probably need to contact your Support Provider if everyone is having the problem, if it'...

Patience. If anyone can, they will. Sybase Server warning 2601 (severity 14) from stored procedure 'Input_1', line 1: Attempt to insert duplicate key row in object 'cus_water_main' with unique index 'pk_cus_water_main' At row 36844, link "DSLink2" This is the heart of your problem. Look at the data ...

Why not just this rather than convert the whole thing and then substring?

Or perhaps just a TO_CHAR() of the field in the source sql.