DSXchange

Hello everyone Although I have a rather extensive experience with DataStage this is my 1st installation of MetaStage((well, the 0th one was in 2000 but nothing much came out of MetaStage V1 as some of you may recall). My installation has been completed, I have the directories (tables) defined on my ...

Thanks very much for all your advices.

Thanks Craig Yes the error message says that the license limit is reached but a simple head count in our office shows that there are not 5 sessions. When you say that "no one can open a new session", what exactly does that mean? Do you get an error, does it tell you your license limit is a...

Hello everybody, We run a configuration of DataStage 6 for 5 users. Quite often we find that although less than 5 people are connected through the Designer or the Manager no one can open a new session. Is there a way to check and list all the open sessions? Thanks for any input you might bring. Jean...

Hello You probably wrote your routine as a Before/After routine. In order to get more flexibility, you can redefine your routine as a Transform function. Then the ErrorCode can be passed either as a parameter as you do now or within the Ans. The Ans is the code returned by the activation of the rout...

This sounds like a great answer. If few bucks can solve a technical problem and help make the wise decisions in a multi-million (add your own currency here) project, we will go for it. Now let me rephrase my question: For all those who bought the licensed driver, are there any who use it with versio...

Guten Tag Wolfgang This is correct, there is some tricky counter which prevented the usage of the routine since Merant acquired the rights on the software driver. But there is also a way to neutralize this trick. If all people gave up on the usage of this routine this is most unfortunate. My 2nd que...

Hello everyone A couple of years ago, I was checking this subroutine which comes in the documentation of DataStage and executes a SQL command directly through the ODBC driver. The exercise was interesting and proved to work under certain conditions. I used Version 6.0 of DataStage. The main benefit ...

Hello Did you consider using the Environment Variables? There is a file called DSParams in each project. The DS Administrator defines user variables available to each job in the project. Variables will typically have the same names but different values depending on the project. Dynamic retrieval of ...

Hello May I offer you the routine I wrote? It even formats the message with "\n" end of line. I use this message in an email sent to the operator to keep him busy at home during the long sleepless nights of winter. ;-) Jean-Pierre ========================================== Parameters: JobN...

Thanks very much,

Actually the file is created if it does not exist. But I like the 2nd solution where you write the command to write the file. It allows you to check if your file exists (new or old) and has been opened for usage.

Very neat and well structured,

Thanks a lot.

Jean-Pierre

Hello everyone

I am trying to figure out what is the BASIC instruction to create a sequential file that I could read with an OpenSeq and ReadSeq.

Thanks in advance

Hello, Ray I don't want to compete with you on consulting services. I am quite happy with my present employer. :-) But since my last posting which revived a subjec left dormant for a while I designed a simple scheduler in BASIC which reads an ORACLE table. This table contains the information require...

Hello Everyone I see the problem quite clearly because I have a similar situation. I will explain: 1. My control job runs jobs which use tables which are updated at the beginning of the week. 2. Before running these jobs I check if the tables have been updated and are available. 3. If the tables are...

You must also disable the write cache in the input hash-file.
In this case the records will be written onto the file immediately after being created/processed and therefore immediately available for the look-up.