DSXchange

What I meant to say here that if there indeed was a duplicate y record and it was erred off, you wouldn't know which x record/seq it belong to

I don't think sorting is the primary issue to the original question. From the input data described above, I don't see any relationship between x records and y records. Even if the data described is in the correct order, how would you know which x record a y record belonged to? Until this relationshi...

I did something similiar to this but I broke it up into two routines. The first routine stored the keyed value in one job and the second routine retrieved it in a subsequent job

john

As long as both files have the same row delimeter, try making the column width varchar(250). Should handle both 250 and 100

Searching FAQs for DEFFUN may give you a good starting point for researching the issue

There is a post in FAQs that addresses this

viewtopic.php?t=92038

We had a situation where we had to add an environmental variable created in Administrator to approx 60 jobs. We first created the variable with a default value. When we went to add the variable to each job, the default value was being populated. Realizing that this value could change, I found that u...

One way is to open the job properties of a job, click on Parameters then click on Add Environemnt Varaible in the lower right hand corner


John F.

I've searched this forum for any info on exporting a single DataStage component via a commandline process and the closet I've seen is using dscmdexport to export the whole project. My question is - If I can export a single component via Manager from a project as an XML file,setting the options I nee...

In my experiences with lookups, I have found that if you are using constraints on a lookup, the NOTFOUND variable on the link works only with hash lookups. If you need to put a constraint on an ODBC lookup you have to check for ISNULL(hashkey)


John F.