DSXchange

So, based on the part that I quoted, the expected result is nothing?

Which ODBC driver are you using with this Connector?

There is absolutely no way you can get 1SH out of those records! To get the fourth comma-delimited field you need Field(InLink.TheString, ",", 4, 1) I'm assuming here that "ch,dat" is a typo, that you meant "ch.dat". Otherwise you need a slightly more esoteric function ...

rapaka89 wrote:...
File format of mon.csv
12345,ghghgh,678,fof90
98766,oeoeoo,543,huh3

so the expected result of the script is

initially ...

Did you leave something important out? Perhaps you can go back and edit your post (don't bother to create a new one!).

Step 1 is to read the Connectivity Guide for DB2. This is part of your standard manual set.

What is IN this CSV file? We can't solve your problem without some view of the source data!

That's why I always name job parameters beginning with "jp" - it makes it obvious in expressions and routines what they are. Next question. Do you need to understand the shell script, to understand the DataStage BASIC code, or to get something working that is not producing the expected res...

DO NOT change your client's data. Find out what this character is - probably an em dash or an en dash - and process it appropriately.

Whatever you've got. If it's not in your source, you haven't got it. Try synonyms like LastName, FamilyName, PrimaryName.

OK, one question down, many doubtless to follow. Where do variables LogPath, CrossReferenceTable, JobPID, StagePID, DB2Schema, NaturalKeyColumnName, TDPATHbin, LogSubject get their values initialized? You can't call the while command by itself in a call to DSExecute. You would have to build the enti...

Determine a particular Julian timestamp and increment it by one second per row.

Lookup with Continue will only return one row from the reference input unless you enable "multiple rows returned" on that input. This can only be enabled on one reference input per Lookup stage.

Stop trying to shoehorn potentially 512 characters into a string that can only accept 256.

That is, get the metadata aligned on input and output links.

We can't answer that without knowing the source data that produced these results.