DSXchange

Hi,

When iam trying to load the oracle table the following warning message appears.

JB01..xfm_xyz: ORA-01861: literal does not match format string

anybody explain about it PLEASE

NAREN

Thanks Ken.It works fine for me. I have a folder which contains filenames. Now i want to pass this Filenames at runtime.How can i implement this? Any clues pls Naren Add the filename as a job parameter, for example. FRED. At runtime, supply FRED a value using the smart job control you are working on...

hi

Exactly. Thats what i want to do?.Can you help to implement that logic Ken?If possible can you give me some sample code please. Thanks, Naren You can do anything. There are documented APIs to lock, set, and run jobs according to the methods you want. Do you want to read a file, get a list of jobname...

Hi

I have a multiple files in a sequential file. Based on on the filename can i call the jobs?. Is it possible in job control logic?.If so ,explain me bit more


Thanks,
naren

How to set a filename as a job parameter? please explain me thanks, naren Only if you used a job parameter as the filename, then the job parameter is also available in the transformer. Otherwise, unless you are willing to use an reverse-engineered method for retrieving job design information, no.

Hi,

can we FTP a folder from Windows NT to Unix server using FTP stage?.If so, How?.what are the properties do we need to set?

Thanks,
Naren

Hi
How to write a Job Control Routine?.From any server job can we control other jobs?
pls explain

thanks,
naren

Hi
Is there a way to pass the filename being loaded from a sequential file stage into a transformer stage in order to have the filename included as an output field?

Thanks in advance for your help.

Naren

Hi I am writing a After job routine like $INCLUDE DSINCLUDE JOBCONTROL.H PathName = "path" OpenSeq PathName To FileVar Else Call DSLogWarn("Cannot open ":PathName, "CALLJOB") End ReadSeq FileLine From FileVar Then If Substrings(FileLine,1,4)="XYPR" Then hJob =...

why dont u test like this
If Not(IsNull(FieldA)) Then
FieldA
Else
FieldB
[/quote]

Use the following statement in your after job routine.
Call DSExecute("UNIX","rm FILEPATH", Output, SystemReturnCode)
ErrorCode=0[/quote]

can you eaplain it bit more pls

Sainath.Srinivasan wrote:Naren6876,

You requirement appear to be different from the working of project level parameters. You may get away using routines and user status. Search in the forum for more details.

Hi I have a folder with some files.I can read this filenames with the Folder Stage. I want to pass this filenames as Project parameters as i need to insert this file name in DB. Any clues pls, Thanks in advance The way it works is that you need to define your project level properties in DataStage ad...

Hi, I wrote a after job routine that capture the log information and it writes the log data to the text file.I used that routine for a single job it worksfine. My requirement is capture the warnings of the each job in the sequencer and finally need to write all the warnings from all the jobs in the ...