DSXchange

Hi, I have a DataStage Server Routine, which connects to DB2, I need to modify the Server Routine to connect to SQL Server Database (Installed on Different Server). I have DSN Name,USER ID, PASSWORD. I have also set up ODBC to connect to SQL SERVER on my DataStage Server. I need to know the syntax t...

If you have the DS administrator rights, then you will be able to delete it... though you get a warning first. Say ok for that warning and then another window will pop up to delete the routine. Yes I had tried with the "isadmin" user with administrator rights, but it didn't work. Do you k...

Friends, I had imported DataStage Routine from a protected project (Project 1), into another project (Project 2), now it is read only in the new project (Project 2). I'm not able to delete the routine, nor does it allows to be overwritten from the Project 1, after unprotecting it and re-importing in...

Friends, I have a simple job which reads a sequential file, uses a parallel transformer and writes into sequential file. I have installed DataStage 7.5x2 on Windows 2003 server with Service pack 1. I have also installed Microsoft Visual Studio .Net before installing DataStage for C++ compiler. I get...

Ray / Suresh, I did have windows 2003 service pack 1 installed. Find the variable set for compiler. These are default settings, let me know if I need to set them and as was. Appreciate your help as of now, hope this gets resolved soon. APT_COMPILEOPT -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c APT_COMP...

I re-installed DataStage on Windows, I do not get this error now. It was a simple job, copy sequential file to another sequential file, I have another problem in compiling transformer (dump attached). I had installed Visual Studio 6 before installing DataStage 7.5x2 on Windows 2003 Advanced Server. ...

I get the following error when I RUN the job "Error setting up internal communications (fifo \\.\pipe\prjDev-RT_SC2-CopyOftest1)". Can anyone please let me know what would be the cause ?

Mahesh, is the core file generated from the compiler or from DataStage? (you can use dbx or mdb or get your System Administrator to tell you). There is little Ascential can do if it is the compiler coring out. ArndW, Thanks for your reply.Can you please elaborate on dbx or mdb ?? What should I requ...

Exactly how are you "flattening" the file with a Sequential File stage? As far as I am aware the Complex Flat File stage is the preferred stage for handling an OCCURS clause. Mahesh: Please refer the part of cobol format from the file,Ray,we had used complex flat file too,but here "B...

We have an Error "when checking composite operator: Output from subprocess: CC: Fatal error in ccfe: Segmentation Fault (core dumped)" when compiling job.We have flattened metadata using Sequential File Stage, there are 3880 fields.The cobol metadata used by the file contains Occurs clause...

Welcome aboard! :D Best practice is never to abort, so that you retain control. Pre-process the data to look for violations. If any is found, your job sequence can choose not to run the "real" job. Or to run an intermediate job to correct those violations, if such action is appopriate/pos...

Hi Mahesh, 1) I need to summarize (sum total) 1 column and get record count of input data using a transformer (BASIC or PARALLEL).I want to avoid using Aggregator.Also since I need to call a server routine, I need to use BASIC transformer. To sum 1 column using a transformer, you can use stage vari...

1) I need to summarize (sum total) 1 column and get record count of input data using a transformer (BASIC or PARALLEL).I want to avoid using Aggregator.Also since I need to call a server routine, I need to use BASIC transformer. 2)I cannot call server routine from parallel transformer.Can i abort a ...