DSXchange

You need to be more clear. Use a server job, since it must operate in sequential mode in any case.

Prove to us what's in the hashed file. From the Administrator client, execute the command

It's correct that scripts can not prompt for input when invoked from DataStage (by whatever method). This is because DataStage processes are background processes. Nowhere in this thread has any requirement to prompt for input been mentioned. Therefore all answers given have been valid. Do you REALLY...

Welcome aboard. :D Did you think to search the forum? This question has been asked and answered in the past. Essentially you need to be aware that the sequence is a record in a Repository table called SDKSequences; the name of the sequence is the key to the record, and the next key value is stored i...

Some are completely undocumented. Some are documented in DataStage manuals. Others are documented in IBM UniVerse manuals

There is a path through your logic where the Ans variable is not assigned a value. In your code, Ans is only assigned a value if the Else clause of the OpenSeq statement is executed. Make sure you always assign a value to Ans.

Does the Folder stage have a filter option?

I don't think so. Sort temporary files have names like sortnnnnnnnnnaa. My guess is that they're something to do with the RTI components.

Not possible unless you can guarantee that these are the only files in the directory.

Prefer a sequential file stage if the files have the same structure, or two separate data streams otherwise.

Create job parameters using "Add Environment Variable". Use one of the special default values.

$ENV obtain value from executing user's environment

$PROJDEF obtain value from project (set in Administrator client)

vardhan354 wrote:Can any help in this issue.

I do not get up at 2:45am (my local time when you posted this) just to answer DSXchange posts!

READNEXT gets the next key value; you will still need to issue a READ statement. If you only want the first record (and, remember, it is not predictable what the first record will be), then you don't need the LOOP in Kim's code. The following would work. Cmd = "SELECT * FROM MyHashedFile FIRST ...

Do not - ever - delete files/directories with names beginning DS_ or RT_ because these are the hashed files that make up your DataStage Repository database.

Where are the soa* files located? What permission do you have to their directory?

There are no global tools; everything is unique to its own project. You could, of course, wrap per-project information gathering into a consolidated report using your own utility, be it a shell script or some kind of DataStage API utility. Foreach project Foreach job in project Foreach invocation of...

It is still beta, except for the Transformation Extender (DataStage TX, formerly known as Mercator).

It is owned by IBM; Ascential no longer exists. Your support provider for your 7.1 version should be able to provide all the information you require; if not, why are you paying them?

How long is a piece of string? The best way to deal with them is to estimate a timeline to effect the fixes that is exorbitant - make them think about the implications of their requirements. I can not advise on "the best" way - it depends totally on what you actually need to do - it will almost cert...