DSXchange

Hello,

It is looking for a configuration file, config.apt, under $APT_ORCHHOME/etc. Place the configuration file with which you created the datasets under this folder and then try to dump the dataset successfully before deleting them.

If anyone has a different opinion, let us know.

I am sure you would have created an ODBC connection for DB2 in the ODBC connections, but, wanted to check on it.

Ravi,

If auto write is true then why are you writing the record using explicit WriteRecord command. Set auto transfer also as true. Define the variables like mindiv, q,div res,rem in the pre-loop tab as to what data type they are. For eg. int mindiv;

save and compile and let us know what happens

Hi, This can be done using a DataStage job and a script which can be called as an after job routine. Steps: 1. Create a column Srrgt_Dist_Ctry_Cd. This value should be same for the country and should increment for the next country. Hence, use a transformer to create the below output: Country_cd city...

how was the datasets deleted? using the dataset tool management or the orchadmin command?

wouldn't a script be more efficient?

write a script to truncate the table. use the sequencer stage to call the script and do the rest of sequencer upon successfull completion of this job.

Hi,

Please check the following:

1. Did u inlcude the header file #include "iostream.h"?
2. I have not seen reading the record, so I assume that you have given auto read as true. If not read the record.
3. Check whether you have defined all the variables in the pre-loop.

Hello,

I believe the job that you have designed consists of only a transformer and then a DB2 API stage. This would not work. Provide a row generator to generate a dummy row with dummy value and then a transformer and then the DB2API.

Hello All, My replies were never meant to cast a doubt on some of the best consultants in DataStage. But, as Einstein said; "The brave Swabian wouldnt' be afraid"; in breaking the established principles to seek the truth, whatever that may be. I was looking for a path to establish the trut...

Thank you Craig for your response!

To all dsxchange members,
Is there a different view than expressed by Craig for my question?

Appreciate your time and the reponse.

Hello, I am trying to establish Oracle connectivity in DataStage installed on windows server. Please find below the details: 1. DataStage is installed on a virtual server, windows 2003 server. 2. Oracle is installed on a different server (111.11.1.1), windows 2003 server. I have given the following ...

Hello, I am using a routine to write the DataStage error message to a file in UNIX. The issue is I am not able to get the complete message. 1. I am using the routine DSGetLogSummary to get the details as below: ReportText = DSGetLogSummary(DSJ.ME, DSJ.LOGFATAL, JobStartTimeStamp,JobLastTimeStamp,100...

Thank you Ray!!

Sometimes, just a spark is needed to ignite the engine

I was able to update the routines as NRO using the command in my above post. The only difference I made was considered the DSRID field as varchar. Thanks for the input.

Hello All,

If I have to describe the tables, DS_ROUTINES or DS_CONTAINERS, what would be the command that I should fire at my administrator command line?

Appreicate your response.

Hello All, I have a set of routines which are in read only mode. I want to delete or over write them. 1. The simplest: I exported the modifed routine to over write the existing one. But could not: Because I was not able to over write a read only routine. 2. I failed in deleting the read only routine...