DSXchange

This is a topic for an orphaned message.

Heres an extract from the output of HELP BCI SQLFreeStmt: | SQL.CLOSE Closes any open cursor associated with the SQL | | statement environment and discards pending | | results at the data source. Using the SQL.CLOSE | | option cancels the current query. All parameter | | markers and columns remain b...

Hi, you could probably write the log to a file whenever there is a warning or a fatal error and then use blat (freely available) to send the email. regards, aedla -----Original Message----- From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us] Sent: Tue 9/3/2002 8:48 PM To: datastage-users@oliver...

Assuming you are feeding the bulk loader stage from a Transformer stage, you can execute an after-stage subroutine ExecSH from that Transformer stage, with your command (no other changes) as the command line. If your command fails, ExecSH will set its ErrorCode argument to a non-zero value, aborting...

Basically you need to free the Statement environment before you can execute the second statement. Check out the help or manual on SQLFreeStmt() for information; there are variations on whether you want to keep column bindings to result sets and so on. The result of the first statement is not automat...

I have to execute several sql statements in a Job Control, using the SQL Call Interface I first do all the connection tasks : Status=SQLAllocEnv(hEnvS) Status=SQLAllocConnect(hEnvS,hConnS) Status=SQLConnect(hConnS,DsnStg,UserStg,PwdStg) If StatusSQL.SUCCESS Then GoTo ConnectErrorStg Status=SQLAllocS...

Hi all I have a job that writes to a bulk loader. After the batch file is created to load the table, I need to chmod the file in order to make the batch file an executable. Currently I have tried the following command in both the before and after prompts which do not chmod the required file. chmod 7...

Hi all, I have the follow parameter in my job: PARTABLES = TABLEA TABLEB TABLEC and i have a function that returns the values: getTable(TABLEA TABLEB TABLEC,1)=TABLEA getTable(TABLEA TABLEB TABLEC,2)=TABLEB getTable(TABLEA TABLEB TABLEC,3)=TABLEC Its possible in ORAOCI8 to call the getTable function...

Hi, I wish to run a UNIX shell command in a before job routine using the ExecSH command. The unix command I wish to run is as follows: if test "`tail -1 xxxxx/xxxxx`" != "" ; then echo "" >> xxxxx/xxxxx ; fi As the directory and file paths are parameterised the actual command in the job routine woul...

Andy, 1))) In theory, Oracle does take row level locks where it can. "surrogate key management table". You might like to explain this a bit further. We use surrogate keys extensively, but have no management table for them. We simply use Oracle sequences to allocate them. As for resolving your lockin...

"Read Committed" is the equivalent of issuing the following statement to Oracle. SET TRANSACTION ISOLATION LEVEL READ COMMITTED; To Quote the Oracle manual (spelling errors and all) ISOLATION LEVEL: Use the ISOLATION LEVEL clause to specify how transactions containing database modifications are hand...

Hi Datastage gurus, Am trying to load data into Oracle database. I am very curious to know what the isolation levels are in datastage. When to use Read committed and when to use the other one? When should we worry about setting isolation level? What is the best approach? Please share your knowledge....

Hi All, 1))) We are having problems when several jobs are concurrently accessing/updating the same table (surrogate key management table). The first job to insert/update the table, takes an exclusive table level lock, and so the other jobs cannot read the table. Does anyone know how to insert/update...

Thanks guys. Thats really cool. We are using DS 4.2 on windows. And it looks like the restriction has been removed since this version. YN --- "Wurlod, Ray (BSG)" wrote: > In the columns grid in a hashed file stage, there is > a column called Position. > In a record in a hashed file, the key is posit...

Hello group,
We have Datastage 4.2.1 installed on an AIX server. We run batch jobs at night and would like to get email notification on warnings and fatal errors. Could someone provide us with the syntax? Thanks, in advance.. Doris