DSXchange

I'm certainly no expert so can't really 'help help' with the analysis... but those numbers seem high to me. Mine are generally two digits, down around the 20ms range. Make sure you run it more than once and at different times of the day. You've also left off the IP addresses / names of the hops whic...

No, a change in the trigger column is what determines when a new file is created. The suggestion was to sort by that column so the values arrive together and you get three files rather than five. Also understand that partitioning could affect the output.

Usually more of a network issue than anything in your configuration, unless you have a minimum rig and you say it is 'decent' so we'll set that aside. How about running a tracert from a DOS prompt on you PC to the ip address of the server?

Still curious about the second question. The best answer for solving that remote problem (which we implemented way back in the 7.x days) is a Citrix server or something else of that ilk. Your client is installed on a Citrix server local to the DataStage server and you connect via a Citrix client... ...

You mentioned your internet speed, does that mean your client is remote with regards to the server? And is this a change in behavior, meaning was it fine in an earlier version or in this version but before the fix pack?

Well, that's good.

I am still under the impression that you need to let DataStage create the sequence. In any case, why not ping your official support provider, see what they say regarding your error?

danddmrs wrote:NLS is disabled in 7.5.2 but not in 9.1.

Ah... that could very well be the issue. Not sure exactly why but it wouldn't surprise me if that's the root cause.

It really seems like there shouldn't be a difference between the two in order to maintain backwards compatability and avoid exactly what you are seeing. However I could see that there could be a difference depending on the coding / seeding of the function. In your shoes I'd suggest contacting your o...

The documentation notes some 'extra steps' are required for DB2 usage of that function: 7. If the database type is DB2, complete some additional steps: a. In the Database name field, type the name of the database. If you leave this field blank, the stage uses the name that is specified by the enviro...

I sent you a PM yesterday asking for your email address, please respond to that with it and I will.

OK... never mind that. I've uploaded it here for anyone that wants to download it before it finds a more permanent home elsewhere.

How was the DB2 Sequence created? From what I recall, the stage has to create it which means a separate one-time job to do that. From what I recall.

Kim took his site down and I think he said that the files would be hosted here... someday. In the meantime, since I'm the one that gave it to him to host I should still have a copy. Let me see if I can find it when I get home.

There are no nulls in a sequential file, what you are seeing is an empty string. So you would need to specifically check for "" (a pair of quotes) rather than NULL to detect them. That or set the NULL value property appropriately in the stage so it converts them for you. Oracle doesn't car...

Seems to me that would be a support question.

At this point I'm wondering more about where than the which... as in where are you when you execute this command? Perhaps you need to fully path the ds? :? I would think a 'not found' error would manifest itself in something more obvious than a '1' return code but who the heck knows? And I've got no...