DSXchange

The input file is a CSV file. The problem is in unix the records are correctly placed in new line. But when the file is viewed through datastage, it does not identify the end of line and gives an error "TOO MANY COLUMNS". Do let me know if there is a place in datastage server edition to de...

The problem is if I am calling the job in script A and passing the parameter APT_CONFIG_FILE to it from script B (where it is getting generated throught some funtion)then it is accepting the value of this parameter. But if I am generating the value of APT_CONFIG_FILE (using the same function ) in th...

dsjob -run -param '$APT_CONFIG_FILE=${APT_CONFIG_FILE}' $PROJPM $Jobname
is not working

dsjob -run -param '$APT_CONFIG_FILE=${APT_CONFIG_FILE}' $PROJPM $Jobname
is not working

dsjob -run -param '$APT_CONFIG_FILE=${APT_CONFIG_FILE}' $PROJPM $Jobname
is giving error

specifying the parameter within single quotes is not working

I am passing the value for APT_CONFIG_FILE environment variable using a function, If the functin is called in a differrent shell script fron the one in which the Datastage job is called then the job runs successfully but if the variable is set in the same script then the job is failed by giving the ...

i have tried using DecimalToDecimal(Link.Field,'round_inf') but this is not giving me the desired output

I have a decimal input and wanted to round it to one decimal place
ie if input is 2.34 output should be 2.3
ans if IP is 2.19 OP should be 2.2

Kindly provide a solution as to how to achieve this

I have a decimal input and wanted to round it to one decimal place
ie if input is 2.34 output should be 2.3
ans if IP is 2.19 OP should be 2.2

Kindly provide a solution as to how to acgieve this

While using the following command : DecimalToString(lReadInput.NRx1,"fix_zero,suppress_zero") I m getting the following warning: "Transformer_0,0: Conversion error converting input field NRx1 to output field NRx1, data may have been lost" My input datatype is decimal(9,3) and out...

thanks it worked

ray.wurlod wrote:Single quote characters (hard quotes) are meaningful to the shell. Among other things, they prevent resolution of environment variable characters and expansion of wildcards. Lose the hard quotes.
[ ...

So shall I replace the single quotes with double quotes or shall I removethem completely?

no its not.. as i have to change the value of the parameter at the run time
thats why i need to send it as parameter only

I am using this command to pass the APT_CONFIG_FILE parameter using dsjob $DSPATH/dsjob -param '$APT_CONFIG_FILE=$APT_CONFIG_FILE' $PROJPM $Jobname When i pass the path istead of $APT_CONFIG_FILE in the command the job runs succseeflle but whn i pass it as paramenter as in the above command its givi...