DSXchange

do you want a row count value in hash file or row count of hash file, depending on situation and requirement you need to apply furhter logic, but DSLinkRowCount can help you to know rowcount.

hello you can use Stored_Procedure stage with no input or output. in output by default you will have ProcCode, ProcMess columns.

in syntax tab you mention your procedure name and take procedure_type tab value as Transform.

I agree with ArndW you need to use a custom code mentioned, in the JOB PROPERTIES IN JOB CONTROL TAB, and run the job, it will execute the code inside it and you can get a result in mentioned/used log file. also you can check Ascential Software Corporation routine UtilityRunJob(sdk) may that help yo...

i daily use this kind of situation regarding insert and update, with Array Size:1500 and Transaction Size:50, I never get a lock issue, Array Size and Transaction Size need to be checked, i agree with sara123.

hello as your web application is using oracle sequence and datastage was already using KeyMgmnt routine,runtime sync is difficult. so as said by ray query your database and increment the value accordingly to create the new number, this logic need to be implemented for both web services and datastage.

hello if you want to do conditional insert.

so what we do is we select records from database and create a hash file, have a lookup of this hash file with input source containing huge records, if records matched no upload otherwise insertion.

put proper constraints in transformer.

please elaborate more on any issue for stored procedure stage.

hello, if i interpret your issue properly, i think in your directory, your getting a files which are used in datastage. just for example if you have a file named test.txt which is used in datastage, you are aware of the name of file that will be used in job, so what you can do is use an after job su...

have you tried taking varchar and tested, with varchar it definitely works.

i think below is your implementation.

Source(sql server)----> transformer----> OCI stage.

in transformer output stage for date column of oracle, put as VARCHAR with proper length and data will get inserted.

hi ray i have a question like what if full outer join has lot of data, say suppose in GB, will merge hamper the performance.

good question, i agree with ray, merge stage will definitely help for outer join.

Hello, i interpret your issue correctly, i think you need few table definitions(Meta data) to be used in jobs. you go on to import plug-in meta data, then give Instance name, username,password. you will get a list of all tables, but if you want to select particular list of tables starting with name ...

hello, if your target column is for database then you need to use database specific date formating like to_date(), otherwise just check for proper length for that date column.

please check for the value of parameter #start_date#