DSXchange

I concur with Ray's assessment that the STAGECOM.ARR approach should only be used for a one-off type of job as it is not documented and likely to change. What you can do is write your data to a named pipe (using no column delimiters and no quotes) and then read that pipe as a 1 varchar() column. You...

ppalka, no, I don't have examples. How and where you program this depends upon which programming language you are most comfortable with, both the DS routine and buildop approach will work. But it does need to be a program versus a line-by-line routine call because of the file structure (data can spa...

They can give you the magic 32-bit string; and I've seen some sample CRC32 programs on the WWW where you could plugin that value. If you goal is to be portable, can't you just stick with Ascential's algorithm? It does seem that that there are a couple of ANSI recommendations and perhaps even an ISO ...

ppalka, these files are structured ones with their own format rules; so reading such structures automatically from DS would be like reading XML and XSL - a non-trivial undertaking. So I doubt that IBM/Ascential will make such a plugin unless there is more of a business case. You are best off using a...

From the code I looked at it will get you a common number. So I think that your Java code will produce the same results on different implementations. I don't know which polynomial DS uses for CRC32, though.

I just took a look at the algorithm in C++ and it doesn't use floating point; but the initial polynomial is left up to the implementor to choose and the result changes according to the high/low byte order. You are probably seeing different results because the DataStage and Java implementations use a...

Hello Craig, they won't match (as you've seen). The CRC32 method is a complex one involving building temporary tables and doing polynomial math and it is not standardized. So chances are very high that any implementation will get a different result. But it will always get the same result for the sam...

There is no undelete built into the UniVerse files automatically. I don't know the thread where the recommendation is to remove the LOGIN paragraph (I'll have to check that one out to see why), but normally the LOGIN only has a couple of lines that check to see if the process is a PHantom and to dis...

Salil, The error message you are getting means that you haven't filled in all the attributes required in the Oracle stage. If you open up the Oracle stage on your designer canvas one of the values will be empty (and red). If you changed the load type between one that works and one that doesn't you s...

Don't forget about "more accurate", either

Hello Koojo, the DSExecute() command will open up a command shell in the current working directory (the project in which your DataStage job is running). Once the command returns back to the DataStage job this shell is closed; so doing a DSExecute() to cd to another directory and then using another D...

Kamesh, The UNLOCK is not a command in the DataStage projects, it is only found in the master UV account. How are you going about using the UNLOCK command? It should be used very carefully as inadvertantly unlocking the wrong processes can cause job aborts and malfunctions. The job administration op...

You only need to declare your Excel sheet as a system ODBC data source and you are in business.

Fortunately you are on a Windows platform so this is easy; if the DS server is on UNIX and you need to access Excel it becomes a bit more complicated and expensive.

ajit,

have you tried it?

I can't help you there. If your problem is as you stated, the bad records will have a different number of delimiters using the DCOUNT function and the constraint should catch it.

I would add an "ugly" stream (sorry, but I couldn't resist the temptation and I loved the movie).