DSXchange

If you have multiple sql and want to capture all the result then try to output to a file and once the procedure is finished read the file and put it in the output log.

Cheers
Siva

Hi

The reason could be becos the procedure sends two output out of which datastage gets the last output regardless whatever is been done before. Either you could take out the Print command or try to call two procedures (which is not efficient).

Thanks
Siva

As you mentioned it is possible becos of client switcher the VC behaves strange. I haven't got the answer from Ascential yet. The version control complely shutdowns without any error messages. It doesn't even say it's going to close the application

Thanks
Siva

Hi Badri

You had missed the syntax.

Try this Ereplace( Trim(Oconv(@DATE, "D YMD[4,2,2]")), " ", "")

Cheers
Siva

One more thing which I had forgotten to mention was that we use two clients one for 5.2 and another one for 7.1 .

Cheers
Rasi

In the Datastage Designer there is an option in the Format tab of Sequential File Stage which says "Supress row truncation warnings". You can use it to supress for too many columns. You can do like what Ray mentioned as making this as Single column and in addition to that Design a job whic...

hi

if you can bring your input into fixed fields then you can use Pivot stage. Otherwise you need to code this in basic.

Thanks
Rasi

Thanks for the replies. I tried in another pc with same configuration also tried reinstalling the client software. Still same problem. I too agree with you both. It seems to be like a bug in the client. I had reported to Ascential. Will update about the outcome from the ascential support.

Thanks
Rasi

Hi

When trying to use the Named Batch in the version control it closes the application. I had tried many times as well as reinstalling the client. Want to know have anyone faced the same problem with Version Control.

Thanks
Rasi

Hi Muru As Ken said you can do that or you can use the mod function(mod(@INROWNUM,7) to split the records. Another way to do is create 7 different hash file and merge is one job. While creating the hash file you need to generate the key either by using the stage variable or use the mod function. Thi...

Things you need to look at 1. Check your filter conditions to seprate header and footer records. 2. Try to do this first and check your hash file 3. If you can see your hash files with header and footer record then check your join condition with your detail records. Once if you had checked the above...

Hi Ken,

After that job started in AIX the users can't even telnet a session to AIX box.

Cheers
Rasi

As far I know there is nothing in Datastage to connect Lotus notes database directly. You can connect to Lotus spreadsheets via odbc.

Cheers
Rasi

goto uv and type DS.TOOLS. A menu will appear and choose 5 from that option which gives you all information about locks.

Rasi

I had a job which is running in (Sun/DS 5.2/Red Brick). This job has 43 ODBC plug-in to extract rows from table and outputs to text file with simple select statement. It is working fine in the this environment. When I export the same job to (AIX/DS 7.1/Red Brick) and ran, it stopped allowing other u...