delimitter

Hi All, I have two questions 1. Our DBDELIMITER setting is "|". Most of our counter part receive "|" as delimiter. Now there is one asking "," as delimiter How could I make it (others are still "|") ? 2. Our DBDATE setting is "MM/DD/YYYY". Most of our counter part receive the format. Now there is one asking "DD/MM/YYYY" format How could I make it (others are still using "MM/DD/YYYY") ? TIA, --garnadi

Garnadi <garnadi@kpei.co.id> schrieb in im Newsbeitrag: 7vb59p$qse$1@news.xmission.com... > 1. > Our DBDELIMITER setting is "|". > Most of our counter part receive "|" as delimiter. > > Now > > there is one asking "," as delimiter > How could I make it (others are still "|") ? > Change your environment for this counter part: create a shell script: DBDELIMTER=, export DBDELIMTER call your job from the shell script Other possibility: if using sql statements to unload or load: unload to file dbdelimiter "," select ... load from file dbdelimiter "," insert .... > 2. > Our DBDATE setting is "MM/DD/YYYY". > Most of our counter part receive the format. > > Now > > there is one asking "DD/MM/YYYY" format > How could I make it (others are still using "MM/DD/YYYY") ? > Change your environment for this counter part: create a shell script: DBDATE=DMY4/export DBDATE call your job from the shell script HTH -- Reinhard