DSXchange

Hi Craig & Ray,

I removed the quote at the third argument and completely the fourth argument. Still the output is coming as "1" for the first record and zeros for all other records.

Kindly looking forward for your advise to resolve this issue.

Thanks,
Tony

Hi Craig, I tried to sample with one stage variable which is Col_E. The derivation for Col_E is "Col_E = Field("DSLink5.Col_D","&","2","2")". The job ran fine but the output was filled only with zeros except for the first record which had the val...

Thanks for the advise Craig.

The string is '&' delimited. I'd thought of using DCount and Field functions earlier. But the part which really confuses is the irregular pattern of columns in the data.

What should be the approach if I use stage variables and Field function?

Hi AGPT,

Can you post the complete error log?

And I guess DSEE(Parallel Extender) would be right forum for your query.

-Tony

Hi Ray,

Kindly requesting the logic I should be using in the stage variables to get the desired output?

Thanks in advance...

Hi Craig,

Yes I need to parse the data and map it to the target variables.

The target will contain around 300 columns which has to be populated by parsing Col D.

Hi Priyadarshi, I seperated the Col D into a sequential file and tried to read from that file. Since the record starts with different columns the mapping with the target variable is not possible. Also trying to fix a metadata to this long string fails because the columns doesn't follow any fixed pat...

Hi All, One of the data sources in my project is DB2 tables in AS/400 system. The data structure of the table is as follows: Col A,Col B,Col C,Col D 1234,ab2f,pazz,"&Col E=ZZ&Col F= &Col G=5478&Col H=100.00 2345,cd3f,ddzz,"&Col F=IN&Col G=9801&Col H=250.25&C...

Hi Craig & Ray,

Thanks a lot for the solution.

The functions mentioned helped me to complete the validations.

I'm marking the topic as resolved and thanks a lot again.

Tony[/i]

Thanks Craig for the reply.

I'll try the functions as advised by you and post the results.

I guess I was not clear with the first criteria regarding the length. The example should've been like this "123678" instead of "123456089012"

Thanks again....

Hi All, I have a requirement in my current project to do a validation check on a key column. The column is the account key which is a 12 digit integer. The business requirements are to check the column for the following constraints and if it fails in any one of the constraints, then the record is to...

Hi All, I tried to load the VMdb220.so (DB2 Wire Protocol Driver) using the ivtestlib tool but the driver could not be loaded into the memory and the following is the error message I got: exec(): 0509-036 Cannot load program /datastage/dsadm/Ascential/DataStage/brande d_odbc/lib/VMdb220.so because o...

Hi All, I tried to execute the odbc shell scripts and got the corresponding error messages in the server. Kindly requesting support on how these errors can be rectified. odbc.sh (ran this script on ksh & bsh) if [ "$LIBPATH" = "" ] then LIBPATH=/datastage/dsadm/Ascential/Data...

Thanks a lot to everybody, I now have an working ODBC connection.
I'm marking the topic as resolved.

Thanks a lot Craig & Hailun for the solutions provided.

Rajngt, thanks to you too. Could you kindly tell how a DB2 connection can be made from dsenv file in AIX systems.