DSXchange

Hi, I have written a routine, in which I am reading from a file and doing some operations. Now after the Routines reaches the end of file it returns a status code 1, which means end of file reached. which is fine. but I want to reset the status to 0(only if end of file is reached), in the same routi...

use deffun RoutineName(A1,A2) calling "DSU.RoutineName" for each of the routine. For example: Say I have a routine 'GetFileSize' with arguments "FileName"and"FilePath", which gives me file size when i Pass input Argument. Now if I have to use this function in some other...

sorry a small correction, the above query will give ora-00917, as I missed out right parenthesis ')' in the end.

well I would suggest is, read the column as varchar2(10) through-out all the stages from source till last oracle stage and then write a USER-Defined Query, in which for that column you use date function. Insert into <Table name> (Col1,Col2) values (:1,To_date(:2,'MM/DD/YYYY'). There will be no overh...

well i was also fed up with such kind of error, so to resolve I have made a practice as described below: say my file has col1 as date having, date format: MM/DD/YYYY. I declare col1 as varchar2(10) in all the stages(including oracle stage) of my Job and then I write a user defined sql, say for inser...

Result = DSGetJobInfo (JobHandle,DSJ.PARAMLIST)--returns a comma-separated list of parameter names. Result = DSGetParamInfo(JobHandle, ParamName,InfoType) InfoType Specifies the information required and may be one of: Result depends on the specified InfoType, as follows: DSJ.PARAMDEFAULT String - Cu...

If you want to do it on Datastage, you can write DS basic code, in your job control.Sort the data on transaction_id.Then read from the sequential file(sequentially) and for every NEW transaction_id open a new sequential file (<file name>.transaction_id) to write the records , for this use the same l...

i can think of a way, say your current sql statement is something like scott.acct for one of the job. step1: I would first declare a job parameter "SchemaName" in all my 200 DS jobs, with default value as "scott". ways of declaring job parameter in all jobs: 1. manually 2. using ...

Use of aggregator is the best and simplest way as Kcbland has suggested. Use of hash file or a database is an extra overhead and its not advisable as its not a good design. As you can think of if your source file size is huge, then your going to eat up lots of space of your server/Database if you ha...

yep i have seen that. The first time i created a job sequence with just two job_activity stage. I was terrified to see some 50 lines code , for just two stages.

Thanks, Ray & xcb

Yep its a job sequence only . With Job Sequence in my previous thread I meant GUI only, but I didnt phrase the word properly.
I am also very new to Basic Code. So learning through R&D enjoying it.

In one of my job, i wanted to call a routine(transform) in the job control to get a value then passing that derived value to a job invoked in the same job control. I was geting error message: Array 'Routinename' never dimensioned.It was considering the 'Routinename' as an array, as the the call was ...

Hey,
Just trying to be more specific.If table name given in SQL query is incorrect and the table does not exist, the error will be ORA-00903: invalid table name.
If the incorrect Table name exist in the Data-Base then only you will get ORA-00904: invalid column name.

An Alternative method, without using Job sequence. Say You server jobname is JOBA. I will create another server job JOBB, with all the parameters, that you have defined for JOBA. JOBB wont be having any mappings/stages. In the Job Control of JOBB, i will write a piece of code, like: SITE,DBName,DBUs...