DSXchange

Look into the sequential file stage, specifically, into the ReadMethod = 'File Pattern'.

What was the schema when you built the file? WHat is the schema when you are reading it?

inside your routine. Add a line at the end. Something like

Inside the routine you can use DSLogEvent() function to spit out the value of KeyMgtGetNextValue() to the job sequence's log.

What does 'status' mean? how are you getting that value? This should have been asked in the very begining.

Do an exact search on 'input buffer overrun'

Ok, i finally got the chance to complete it. #include "stdio.h" #include "string.h" #include "stdlib.h" char* pxEreplace(char *str, char *subStr, char *rep, int num, int beg) { char *result = (char *)malloc (sizeof(char *)); int newl...

It doesnt matter how many values are there. Its horizontal data being pivoted. The final meta data will remain constant. The pivot stage will get this done. I am not saying just one pivot stage. You might need to parse your data a little bit too.

Hmm. Well, i guess the only other way is to build a dataset using the query and do the join in datastage on all seven columns. Yea, do that, build the dataset with the following query SELECT F.col1, (CASE F.col2 WHEN '*' THEN (SELECT sub_D.col2 from DataBaseTable sub_D where sub_D.col1 = F.c...

If i understood your requirement then do this:
Get that reference date in a UserStatus. Check it in a stage variable. If its empty then NOT(lookup.NOTFOUND) else @TRUE. Specify stage variable name in the constraint.

Use the Read method as 'File Pattern' and then give your FILENAME*.

ray.wurlod wrote:Missing a "g"?

Was missing it , Kumar filled in the space....Thanks Kumar.

When you test your routine from command line, does it work, how are you compiling the source code, make sure you compile it with the +Z option.

Try by trimming the fields first before doing your inequality check. There might be a trailing space or two. Make those columns varchar.

As Craig noted, its not possible at the level we work. Thats Operating System programming which I doubt you want to get into.