DSXchange

It might be the class A IP address. Can you ping 18.37.20.20 from the DataStage server machine? Given that both databases are SQL Server, and that they are identically configured (same driver, same port) it's got to be something about the connectivity. Also check that MYS_SIEBEL_DB really is using p...

... and how do you think the tail command works out which are the final lines in the file?

Open the DSX file with any text editor and change the CharacterSet property (it's very near the top of the file) to the appropriate value.

Export files are always made on the client, so that the operating system of the server should be irrelevant.

You've changed your mind! In your first post you specified "After completion this job, I want to generate one more seq no in second job i.e max no in the first job+1." That's the solution I provided. To begin from 1 each time, you can use @INROWNUM or @OUTROWNUM as Craig suggested, or reset the sequ...

Surely at the very least it would need dsobjects.dll. That the one through which a connection is made to projects. Doubtless there will be others on which dscmdexport.exe depends, either directly or indirectly. Not sure how much can be deployed without paying for extra licensing; you should obtain a...

Surely, then, it was I who solved your problem?

Linux version and compiler version are VERY sensitive! Hopefully someone with precise knowledge will post exactly what can and can't be done. Have you posted this on Ascential Developer Net ? Does your Sequential File stage have a rejects link? What is the value of the rejects handling property?

That's one for my Favorites page! :D

You must keep knowledge of where the first job left off. The easiest way is to design so that this is kept in a file (text file or hashed file). Before the first run, initialize the value in this file to 0. From your job, maintain your sequence however you like. Create an output link that passes onl...

Don't do anything you don't have to. This includes: Be selective when extracting data to process; only select the rows you need from source, rather than grabbing them all then discarding some in DataStage. (This is not applicable for sequential files, where you necessarily have to read them sequenti...

That one's easy: you can't. With no way of determining the record type from within the data, and no a priori knowledge of the number of lines in the file, you're stuck. An easy mechanism, however, is to have a little routine that captures the number of lines (be exeuting wc -l command, for example) ...

I doubt that the server forum is a good place to ask this question.

In summary, the SAS stage accesses SAS "directly", whereas the SAS Data Set stage creates a persistent Data Set in a format compatible with SAS.

In a production environment, one warning is too many imho. One should always seek to design server jobs so that they do not generate any warnings. Then, if one ever does occur, it means that something truly unusual has occurred. In parallel jobs it's more difficult to eliminate certain specific warn...

Recompiling, among many other things, does have the effect of resetting stage information in the status file. Or causing another wave number to be used next time the job is run, depending on internal conditions, which I'd prefer not to discuss.

Do you have eighteen squillion jobs in the project? When you open a Job Activity in a job sequence, a sorted list of all jobs in the project has to be requested from the server, sent to the client, and used to populate the drop-down list of job names inside the Job Activity. There's probably some tu...