DSXchange

Speed of search can be improved by using BY seq clause in both LOCATE statements.

I agree with Arnd. Take two backups. That number of errors is weird - UV_SCHEMA ought only to contain very few records. You might like to involve your support provider, as there may be an issue with mismatched file units going on here. Before trying a fix, can you add the option -level 5 to the fixt...

Try this. The single physical key is typically made up of values separated by text mark characters (@TM).

There's even a DSXchange Learning Center Webinar on exactly this topic - how to use job sequences to process file-based lists or lists of file names.

You can change just one parameter in the set leaving the others to default using "dot notation" syntax. There was a recent Webinar on how to use Parameter Sets.

Even easier is to use the Help (About) menu in any DataStage client.

That's a good response. It means that the VOC pointer has been created. There are many more, some of which the system needs. A pre-stored query that will show them is LISTFR (executed at TCL).

NOT telnet!!! Go there physically. Or use Remote Console.

The client prevents you from editing out-of-the-box rule sets. However, you can edit the rule set files (they are all text files) directly.

There is a Windows machine on which DataStage server is installed.
Can you login to that machine - ignore any IBM software for the moment - can you achieve a Windows login on the Windows machine? If so, can you open a CMD shell there?

It uses ODBC protocol to connect to Unidata.

• SQLAllocEnv()
  SQLAllocConnect()
  SQLSetConnectOption() as many times as needed
  SQLConnect()

NOT from the client.

"directly on the server", for example using its console.

Can you log in to Windows using a CMD shell directly on the server?

And they ask me to respond to.... AmI staisfied? Sure we spend all this money and there going to ask us to do the ETL in the database or withing shell scripts!!! Hello John, Since the job is working with the workaround and there is nothing additional I can assist with for this PMR, may I close it? ...

Use Information Server web console to reset the password or create a new user ID for testing. Make sure that the domain name given in the connection dialog is the correct hostname (and port 9080) for Information Server.