DSXchange

-1 is the error code DSJE.BADHANDLE

It means that the first argument you've given to DSGetLinkInfo is not a valid job handle.
The only means for generating a valid job handle are:

using the DSJ.ME constant
using the DSAttachJob function

"Running" is the most recent entry the job was able to make in its status file (which is interrogated by Director's status view). You can reset that status by clearing the status file or by recompiling the job. Clearing the status file should be a method of last resort, which is why it asks "are you...

I'd be more concerned with finding out why it aborts, and correcting that situation. How do you know that all of the 250M records were successfully loaded? That said, the approach is basically to determine the row counts - there are many ways to do that - and to use the appropriate one as the start ...

Welcome aboard! :D Your question falls into the categories of "changed data capture" and "slowly changing dimensions", which are often asked here, so a search of the forum for these terms would help you. There are several techniques for both, depending mainly on whether you have your data records al...

This post has a solution, with code, for the difference in completed months. Another post, with some SQL, is here.

The operator in DataStage BASIC is MATCHES rather than LIKE , and it uses a more flexible pattern-matching capability. In your case, all you need is the wild-card pattern element, which is either "..." or "0X". InLink.ColumnName MATCHES "...TBA..." or, for case-insensitive matching UpCase&...

I've just done one from Solaris to AIX, DS 5.2 to 7.0. The main obstacle was changing default values for pathname parameters; which I solved by creating a DataStage routine that post-processes a DSX-format export file.

We ran into one issue. The HashedFile stage can no longer successfully perform a reference lookup in the following circumstances: the hashed file has more than one key column the value of each key column is "" even though this is a valid key, and works OK at 5.2. This was reported (with a reproducib...

Can you not set the metadata definition to VarChar with a precision of 32000?

You could, in the FTP stage, use a "before" command uniquely to identify the latest file and give it a fixed name that FTP could use. Something like:
then use FTP to get the xyz file

I was drafted (and initially unhappy about it) during the VietNam conflict. Does that help?

Woody grew up in Okemah, OK where my dad grew up. "In them Oklahoma hills where I was born". You probably like Dylan, CSNY, Buffalo Springfield. How about Hank Williams? Now you're just jumping to conclusions. All I said is I could remember Woody Guthrie. While I do admire some of his work, my main...

Hi Kduke, I got the same issue. As you suggessted i had created RT_CONFIG file and can you pls let me know what entries need to be added in VOC file. Thanks & Regards Saravanan The whole point is that you do not need to create the RT_CONFIG file. There is no such file . Each job has a hashed file c...

kduke wrote:Arlo Guthrie? Are you a hippie? You aren't that old are you, Ray?

Man, I remember Woody Guthrie!
And Maynard G Krebs.

SV1 detects whether a change has occurred.

SV2 remembers the value from the previous row processed (while SV1 is being evaluated).