DSXchange

Thanks. For whatever reason, I was under the impression that adding one via the Administrator gave me the option of using it later to override a value by adding it (unchanged) to a job. Had no clue until this incident made it abundantly clear that, by adding it, you are setting it for all jobs in th...

You will also need to ensure that your commit frequency is each row so that an immediate commit is done from one link before it's successor gets executed. Need? No. You can certainly do it that way, but it's slow and complicates your start/recovery options. Two links into one OCI stage. This will a...

Querying the repository doesn't require a stage. You can either do it from a TCL session initiated from the command line on your server or from the Administrator client. Again, I'd suggest a thorough search of the site. There are many examples of DS_JOBOBJECTS queries here and with a little work on ...

Sure, and there are many posts here that can help you with that. The DB2 stage will have a certain OLETYPE in DS_JOBOBJECTS and you can query for that. Sorry, I don't know what it is off the top of my head so you'll need to do a little digging. Then you would constrain by your particular table name....

Let's give this a shot with the OCI stage. There's no need to create another job that needs to run for each row of the XML file you process. Instead, you can connect to your Oracle database right in the XML job and just issue the singleton query once for every record being processed. As noted, not a...

And it only ever happens when the DataStage server is on Windows. [bzzzzt] This has (recently?) starting happening to us on our HP-UX server. The problem does not happen if we are logged on as a generic 'dsuser' type user via the Administrator, all is fine. However, if I log in as 'dsadm' and click...

my problem is file won't be there if first job processed '0' records file won't create this some other thing No, you will find that unless you are doing something super special - when a job runs that writes to a sequential file, it will always create the file. If the job 'processes 0 records' that ...

As noted, precision is the total number of digits in the number, not the number to the left of the decimal. Scale is the portion of the precision to the right of the decimal.

So, a decimal(3,2) could not store 10 as a value.

ps. Don't count the decimal in the precision.

You should be able to use the Wait For File stage for something like that, if I'm following you. Set the Timeout Length to zero for a one time check. Your problem will be the file will always exist, I would think, as the file will be created in a job but will be empty if nothing is written to it. Yo...

Welcome aboard! You'll find that most questions have already been answered by now (yours included) and that the Search facility of the site can come in very handy. If you search on your error code you'll see what I mean. Long story short - you've overloaded your server. There is a hard-coded timeout...

You add them as job parameters if you might want to override them for that job. Obviously there's a disconnect somewhere, but this statement encapsulates my understanding of how they work. It also seems to be at odds with your first sentence. The 'normal' setting of LC_CTYPE (as one example) is "C"...

Have you tried limiting what is returned using the 'Name Contains' filter?

Interesting. Removing the User Defined entry for this solved the problem. And I then added it back and it is still working. I'm guessing that it probably had a space at the end or something similar, as I didn't notice a typo. Still curious about the 'all the time' thing... not what I was expecting, ...

The only locale reported in the Environment settings log entry is this: LC_CTYPE=C.utf8 And that's the same on both the working and non-working servers, 7.5.1A and 7.5.2. Interesting is the fact that it is reported as "C" from the command line, but I have a User Defined Environment Variable setup vi...

Hadn't found anything in uvconfig when I posted the question, the Administrator confirms it - NLS is not enabled.