DSXchange

Your load was interrupted. You need to issue a Load Terminate command. If your previous load was of type REPLACE, then your table will be truncated. But if it was of type INSERT, it will be restored to a point before the Load command was issued even though you have specified consistancy points.

Because such general terms are vastly described outside this forum. And google is your best friend in such cases. Instead of waiting for someone to post an answer here, it will be much better and faster for you to use google. ArndW was kind enough to give you a brief description in his reply. For mo...

If this is an initial load and you dont care about the data already loaded then truncate the table. Even that takes the table out of load pending state. Something like


Use the above command only if its UDB and not DB2.

In the output of the sequential file stage, specify the quote characters as 000. Also while building the file. Specify the quote character as 000.

O great. Then the Last option is going to work. Ive done something like that in the past and the last option works great.

Yep, couldnt let go of my turn in pulling your leg.
Just something i like to do

Forget the meta plugin for now. Does DS 6.0 DRS stage support Informix. If it does, create an odbc connection to your database and try to use the DRS stage. See whether you get an error with that.

Load that into a temp table, group by the key and get the last one. If you were on server, you could have achieved this by aggregator. I am not sure if the Last option is available in a parallel aggreagator. Or, if the remove duplicate stage works like a hashed file stage, then pass it through the r...

I think this is the source thats creating the problem. What about odbc stage. Can you use the odbc stage to send a select?

Or, you can also use the builtin transform funtion LETTERS(). That will return you all the alphabets from a mixed character string. That is offcourse, if you want to utilize the built-in functions of datastage.

O yes Kumar. Now its my turn, Ray, Craig watch out for kumar has turned on the NOS.
Jokes apart, Congrats Kumar. The site has gained a lot from you, and me personally have grown learning from your posts. Keep it up.
Regards,

You got it.

In otherwords you need to capture the timestamp at row level when that particular row was inserted or updated. Well for inserts, specify that column to get the current timestamp at the table itself. This way you dont even need to pass that particular column. When a row gets inserted, the database wi...

on second thought ^@ is control character for NULL. Convert null to some value like space. You know what, easiest way. Perform a sed operation on it and replace the nulls with a pipe instead of a space so that you can actually see that it did get converted. Something like sed 's/\x00/|/g' file > new...

Then do this


char(094) = ^
char(064) = @