DSXchange

How do I pass the timestamp in job parameter??

Yes. the file name is parameterized.

Hi-

How to append a timestamp to the ouput file in FTPStage ?

Thanks

HI-

I have one question the problem is i have to load records from source to
target (actually i have to insert into the target) the database we are using is oracle. For this i am using oracle stage but here we have no insert option so what do we need to do can anybody help on this

Thanks

logfile: /u01/Ascential/DataStage/Scratch/ora.1081562.905194.0.log for details. Is there more information in the log specified? YES- "Oracle_Enterprise_0,0: SQL*Loader: Release 10.2.0.2.0 - Production on Fri Nov 17 15:30:45 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control Fi...

Hi-

How can we fix this error

error Oracle_Enterprise_0,0: The call to sqlldr failed; the return code = 256;
please see the loader logfile: /u01/Ascential/DataStage/Scratch/ora.1081562.905194.0.log for details.

Thanks.

Hi-

When i run my job i am getting nullable field warnings though it's not actually and the job is getting aborted with the fallowing error

APT_CombinedOperatorController,1: Fatal Error: waitForWriteSignal(): Premature EOF on node etldev No such file or directory what exactly this means.

Thanks.

Are you able to open FTP session from your server on which DataStage is running. Try FTPing a file from UNIX prompt. This is to test if you can even start a FTP session. I am able to open FTP session from unix and also successfully FTPied a file. From datastage the environment variables are not wor...

Laxmi try this, don't make them as $projdef in ur parameters leave it as is in the admin... ex: servername: xyzabc leave it as xyzabc don't change to projdef and try to test it now... I am actually doing ftp from one unix box to another box.I want to try this with FTP enterprise stage to see if it ...

kris18 wrote:Laxmi try this,

don't make them as $projdef in ur parameters leave it as is in the admin... ex: servername: xyzabc leave it as xyzabc don't change to projdef and try to test it now...

I have tried that too but not working.

i think you are making something wrong in specifying the parameters in the admin...try this by doing one by one... i mean to say try to hardcode evrything in the ftp stage run it and c for errors, if you don't find any errors then go by parametrizing username first and leaving the rest hardcoded......

i think you are making something wrong in specifying the parameters in the admin...try this by doing one by one... i mean to say try to hardcode evrything in the ftp stage run it and c for errors, if you don't find any errors then go by parametrizing username first and leaving the rest hardcoded......

laxmi_etl wrote:

narasimha wrote:Try hardcoding the name of your server name in the FTP stage and see if the connection fails again.
Also double check the default you have specified in the Administrator is your server name

Any Suggestions.

Hi- When i am working with one of my jobs i am having problem with lookup stage throughing the fallowing error Lookup_8,0: Could not map table file "/u01/Ascential/DataStage/Datasets/lookuptable.20061113.sqbu0oa (size 540413848 bytes)": Not enough space Error finalizing / saving table /tmp...

Try hardcoding the name of your server name in the FTP stage and see if the connection fails again. Also double check the default you have specified in the Administrator is your server name I have hardcoded the servername and tried to use the parameter for username. I have defined the username in a...