DSXchange

I need it the way you specified.
Can you more elaborate the convert function.

Hi, Business give me a query to get the accountnumbers. the query will be dynamic. I am extracting the query into a file using a parllel job. That file contains the accountnumbers. I am using execute command stage to extract those accountnumbers from file. I need to pass these accountnumbers to a pa...

I want to retrieve them all at once.
Pls explain me how to change the argument to retrieve all account numbers.

Hi, I have execute command activity stage from which I am getting accountnumbers. How to pass all the accounts in to a user variable using user variable activity. I tried using Field(Execute_Command_83.$CommandOutput,@FM,1) in the expression of user variable activity. But it is only giving first acc...

but that 'in list' is dynamic and business want to provide the 'in list' query dynamically whatever they want.
thats why I want to give them a file in Unix to put their query in that file.
is there a way I can acheive this

the error message is
The OCI function OCIStmtExecute returned status-1. Error code:936, Error message: ORA-00936; missing expression

the sql query i posted, i am using it as user defined sql.
i am not reading sql from file
in user defined sql i am calling file which has accountnumber with paramerter/filename.txt.
we use parameters in user defined sql
and that is what i am doing

I am not using parameter in file.
I am writing a query and in that there is subquery which is from file.

ther error message is
The OCI function OCIStmtExecute returned status-1. Error code:936, Error message: ORA-00936; missing expression

Hi, I want to run the following query in OCI stage. select a1.idx,a1.namex,a1.creationdatex,a1.specialhandlingx, a1.CONFIDENTIALX,b.codex from accountjdox a1, brokeragencyjdox b where a1.defaultbroker_fkx=b.idx and a1.idx in(#Dir#/Accountfile.txt) I opt for read sql query from file as NO. I have que...

Hi,
Anybody please help me in getting the sequence level job statistics.
I need to have the sequene start time,end time, elapsed time.
I know at the job level we can use after job subroutine. But I dont know how to get sequence level info.

naming i will do it which is not a problem.
how can i get the desired results after naming convention.

Job start time=2012-07-16 10:47:28 Job end time=2012-07-16 10:47:34 Job elapsed time=00:00:06 Job status=2 (Finished with warnings) Stage: abc_OCI, rows input Stage start time=2012-07-16 10:47:31, end time=2012-07-16 10:47:33, elapsed=00:00:02 Link: DSLink267, 14 rows Stage: Transformer_269, 14 rows...

I need to populate audit table.
The columns I need to populate are
start time
end time
elapsed time
reject records
insert record
update records
elapsed time.
For this I am doing the above said.

can you tell me how to grep them, becuase I am not expert in UNIX and the files are generated with filename_currenttimestamp.
Please help me in grep those files for each sequence run.
I have morethan 10 jobs in the sequence

I am using dsjobrepot after-job-subroutine and getting all job reports to specific directory in txt format. But creating jobname_timestamp. But not able to club individual job report files into one file,because every time they are getting created with different timestamps in unix.as I am not an expe...