DSXchange

Search for a link on this page. It has a few routines, including the one that you want.

Or go the ICONV/OCONV way as Ken suggests

Nothing out of the box but its no sweat. Do a substring and check for your limits. I know MM will be greater than 0 and less than 13. Similarly DD will be between 1 and 31, inclusive. You define YYYY. What is a valid date for you. Do a check on that. If you want to go into more depth, then you can a...

Nothing out of the box. You can click on Ray's footer that will take you to his page. He has a routine that will solve your problem.

Test it out and let us know what you find. See if you are actually able to connect through the DB2 API stage.

I think the OP is referring to the db2 bulk loader.

No secure ftp stage. You could create a sftp script and invoke it within datastage.

Define RFC? Does this relate to SAP by any chance?

Call , You mean use. Yes, by surrounding them with hashes (#).

I think that must be it Craig.
sshetter, the keys you use to build the hashed file must be same and identical and in the same format positionally, when your reading it. Also make sure hashed file names are the same. And the columns should be in the same order too.

That means there there is no hit. You are sure atleast one 'promo_id' is identical in both source and lookup? If affirmative, then trim your source promo_id and the promo_id while building your hashed file. There might be a leading or trailing key thats not giving a hit. Specify them as varchar.

Surround them with double quotes, i.e, "'A690','R456','F1234'"

Just having a little fun

Read this post by Vincent.

I am glad you came back with the solution. Thanks.