DSXchange

Chulett,

Can i call routine from mail body?

Even after Row per Transaction set to 0 its rejects only error records and just leave the warning in the director. but correct records got committed.

Hi,

How can i rollback the entire data that lodaed into the oracle table if my job gives warning? As of now my job commit the data till it encounterd error.

use Fix function

Hi,

Is it possible to pass user variables to mail body?

Hi,

Use Oconv function

Syntax: Oconv(Field,"MCN")

Hi,

I have created bat file using dscmdexport command along with host name,username, password and project for exporting jobs.This command pull all the jobs which resides under many category. But i need to export the jobs only in the particular categories(folder). Please help me.

ill @FM be placed between every column values?

can u give me some scenario or example where i need to use these variables.

i need more details on it.

Hi,

Please explain abt system variables @TM,@FM,@VM.and where to use those variables?

Hi,

First find the length of that field. then
use oconv function with MCN option on the same field to pull only numeric values.if both the length match then ur field contains only numeric value otherwise it would have contain non numeric data.this ill work in server edition. im not sure abt px.