DSXchange

The Director log tells you how many rows were written to the data file. Can you check this, and confirm (or otherwise) that all the lines are there? Use a wc command. If they are, the problem is not in DataStage per se, it's either in the bulk loader itself or how DataStage invokes it. The easiest w...

Well, Arnd hasn't lost all his long-term memory yet, the memory allocation mechanism for strings IS based on a Fibonacci series. There is no practical limit so long as you have some (virtual memory) left. Of course, if you really hammer it you will introduce paging (so your process can get more resi...

ArndW wrote:The only way I know of is to use the graphical interface, just like you did with your development project.

Alternative: You can right-click on the actual message (in Director log view) and create a message handler from there.

Welcome aboard. :D Search the forum for SIGINT; it is one of the standard UNIX signals. Your two statements that "the job is aborting" and "we have to stop it" are mutually antagonistic; if a job has aborted, it is stopped. Did you mean "we have to reset it"? There are many possible causes for a SIG...

To clarify Benouche's post, if you are going to use a partitioned Lookup File Set, it must be partitioned in exactly the same way as the stream input. This guarantees that all lookup keys will be in the correct partition. Since a single sequential file can not readily be partitioned on a column, you...

Yes, it's doable with BASIC. OpenSeq then Seek to end of file. Repeatedly Seek -1 bytes from current position, counting the line termination characters. I note that you're on Windows - you may like to add a check that you really have a CRLF pair. Accumulate the current line in a string, prepending t...

First, there's no need to shout. Some find all upper case offensive. Others might think you're writing in COBOL (gasp!). There is an excellent search facility here. The question you asked has been asked, and answered before, quite comprehensively. Please find it then, if you have more questions, fee...

Read the help/manual again about what the Command stage does. It executes an operating system command, not a DataStage command. Therefore you can use operating system commands such as mv or COPY to accomplish what you seek to do.

No.

However, there is a document about the UniVerse equivalent, that can be found among the UniVerse manuals (use version 9.6) at the IBM "manuals online" website.

It may currently be an integer but "they" reserve the right to change it (for example to a pointer to a structure). Currently it's a row number in a table of pointers to structures. No, you can not have access to that table. Treat it like any other opaque variable (file handle, subroutine handle, co...

Was this version 8 ("Hawk") or version 7.x ?

It is a known - indeed documented - issue for the Hawk release. Did you also get the problem with version 7, or are you just re-posting the solution found in another thread?

It has been tough trying to sustain 2 posts for every one of Craig's. Let's not diminish his imminent achievement of 5,000 posts just because someone else happens to be nearing 10,000. Great fuss was made when I got to 5,000 - the same courtesy should be afforded to others who achieve the same miles...

"DataStage commands" can be entered via the Administrator client or via a telnet session. Where DataStage server is installed on Windows, telnet is a DataStage service. "DataStage commands" can not, in general, be entered from a DOS (or cmd) shell. Your apparent lack of experience/knowledge leads me...

This thread began as a question about hashed files. I have no idea why people responded with thoughts on Aggregator stages. We continue to await a response from sankarsadasivan to the questions posed about the job design, data and hashed file size. Please begin a separate thread if you want to discu...

If, as you claim, you know UV, then you will know of UniObjects, an interface that can present objects via a COM control or as Java classes. DataStage has its equivalent, called dsobjects.dll. This will make available to you all the object you require to access a DataStage repository database. A war...