DSXchange

Try it with exec schemaname.procedurename(). Also try without the trailing semicolon. We had different results on different versions in the recent past.

Build hashed file and dump its contents to a sequential file. Then use that sequential file to build your lookup set or dataset.

You will be able to find this info in the Install and upgrade guide . The following is directly out of the guide If you have installed NLS, you need to edit the $DSHOME/dsenv file to specify the locale that the server uses (this is separate from the default locales for projects or jobs, which can be...

Adding to Ray's suggestion, do an exact search on 'ds_uvput() - Write failed for record id'. You will see that this topic has been covered before, time and again.

I am already laughing No offense apotluri, i was laughing at Ray's funny comments

Check out these two posts. Post 1 and Post 2

You said its a decimal field right, try 0.00 instead or whatever the prcision is, put that many zeros after the decimal. An arror in the dark

you need to first set the db2 environment. It is not able to recognize your commands. Try executing cd $DSHOME and then . ./dsenv , that should take care of it.

O really. So Mr. Ray tried to compile a book huh? Nice. See if you can give it another shot Ray. I can assure you that Ill be one of the top few to purchase it.

ftp does convert it from dos to unix and back. I think we needed to ask this question first, why do you need to use that command in the first place???

Good going Kumar. Great post. Everything in a nice table like format. We like tables, we are dw guys after all

Try

Welcome Aboard
Save it as a CSV file or a tab delimited text file. Read it with a sequential file stage and load it to the database. Pass it via a transformer stage and use trim to trim the leading and trailing white spaces. Make sure you specify the columns as varchar.

It could be YYYY-MM-DD, it could be MM-DD-YYYY. You need to tell us that. We will tell you how to get it converted. Actually the website will.

dos2unix and unix2dos are present on some platforms. Try doing man dos2unix or man unix2dos, if there is help present, then it is most probably supported. Only your id doesnt have access to it. You need to contact your system admin for that.