DSXchange

try Default to decimal output property

check what is set in $APT_PADCHAR variable

concat all files and filename field into one file.
read file, transform and output
do the inverse of concat to reproduce files

:D

try using anonymous plsql block

check for below
-renamed sort columns in output link of sort stagekeeping column names
-check if you have set clear partition anywhere before sort stage

check if this helps
http://www-01.ibm.com/support/docview.w ... s&lang=all

or
check if you can reduce your record length

"monitor has black colour" - may be job monitor has stopped
restart job monitor and run a job and check

what i understand from you requirenent is that you need to do a range lookup which DS8 provides...

approach 1:
split the load into 2 jobs. in the first load insert col1 (pk) and in the next load update col2.

approach 2:
disable fk before load and enable it after load

check all stages from input till join for defaults and nullability

keep it as timestamp in DS

Lookup fileset to be used, if reference data fits into memory and used in multiple jobs

$ENV didn't work.
How can assign the value of environment variable to a job parameter from command line
e.g.
DBPWD -- job parameter
$DBPWD -- environment variable

how can i assign DBPWD with the value of $DBPWD (DBPWD=$DBPWD)

regards,
Madhukar

yes, I implemented with echo $DB_USER $DB_PWD $DB_SERVER. But i have problems with pwd variable which is of type encrypted.

Any suggestions in this regard?

input parameter to sequence name will be a database name.
Based on database name i need to fetch the username and pwd which is set as used defined environment variable