DSXchange

Missed that small point.

Does the same thing happen from other clients, such as Microsoft Query?

If i disconnect the Information Server session using Web Console for Information Server, i will disconnect all sessions, correct ? Not correct. You can identify the particular session. The easiest way it to try to open the locked job, and you will learn the id of the session that owns the lock. Fin...

where ... is wherever you installed the product.

Quel dommage! Can you telnet to the server? (Use PuTTY or similar if secure telnet is required.) If so, can you then get into a DataStage shell (dssh) within the affected project? Chances are that some of the hashed files that make up the project's repository were corrupted when the disk filled. If ...

Yes. You missed learning anything about how operating systems work during your IT career to date. Neither UNIX nor Windows would cope with your syntax. The pathname of the executable must be either a fully qualified pathname, or a pathname relative to the current attach point (current working direct...

There is no problem. The two dates are identical. What did you expect to be the case? You can ask the database server to format dates for viewing any (legal) way that you wish. It would appear that the default format is as specified in ISO 8601, namely YYYY-MM-DD. All ODBC stage types follow ODBC st...

dsjob is not executed from within a dssh shell, which is what you are attempting to do (perhaps via the Administrator client command window). The dsjob command is executed from an operating system shell. This means that the command search list and shared library search list environment variables mu...

The DSSetUserStatus() routine is inbuilt - you won't find it in the project (but you will find it in the DataStage BASIC manual). You will need to construct an interlude function - there are many examples on DSXchange which a Search will turn up.

Invoke KeyMgtGetNextValue() once from the controlling job sequence via a Routine activity.

This forum is not for this kind of question. This forum is to discuss topics about which a more formal FAQ might appear in the FAQ forum.

Topic relocated per request - Andy

Everyone else: please don't answer until the question is in the correct forum.

This forum is not for this kind of question. This forum is to discuss topics about which a more formal FAQ might appear in the FAQ forum.

Relocated per request - Andy

Everyone else: please don't answer until the question is in the correct forum.

This forum is not for this kind of question. This forum is to discuss topics about which a more formal FAQ might appear in the FAQ forum.

Topic relocated per request - Andy

Everyone else: please don't answer until the question is in the correct forum.

gssr wrote: i am not able to read your full content

By now, with well over 100 posts to your name, you should at least have some inkling of the benefits of premium membership. It's not that expensive - less than 30c (Rs12) per day.

You are completely wrong. Parallel routines must be written in C++ (definitely not any kind of BASIC language) then compiled and linked. Finally an entry must be placed in the repository recording the existence, location and required arguments of the routine.

"Best" does not come into it. You need a key-based partitioning algorithm that causes key adjacency - that is, all records that have the same value in those columns that are identified as Change Key candidates must end up on the same partition. If the Change Key is a single integer column,...