DSXchange

The sequence restarts the job, fromt the job which failed in the last run and restart method would work till the job sequence is compiled. The job sequence will start from the 1st job after the job sequence is compiled. Oracle OCI can be found in 'Database' category in the palette. Would suggest you...

Add checkpoint option is to restart the job in the Job sequence from where it failed after the fixing the problem. This would not help rolling back the data in the database. If you want to commit the changes only when insert and update are successful, use OCI stage and enable transaction grouping. T...

You can read the file using OpenSeq/ReadSeq functions. Search the forum/help how to use these functions. DO the error handling based on the obtained exit code.

Regards
Saravanan

Your DBA could help by creating DBLink to join two databases. Using DBLink may degrade the performance of the query.

HTWH.

Regards
Saravanan

Use Jobcontrol to call the batch file. The batch file can be executed using DSExecute function.

HTWH.

Regards
Saravanan

Hi Pongal,

You can also store the last seq number for each load and increment from that seq number in the next load.

Regards
Saravanan

Hi,

In the manager client, the "Extended job view'' option is selected and unselect the option. And follow the steps as mentioned by Arnd then you should be able to delete multiple jobs.

HTWH.

Regards
Saravanan

Hi Shivan,

Are there any warnings in the director? If there are, can you look at the warnings.

Regards
Saravanan

There is one way(it may not be nice way) to execute the Oracle stored procudure by calling SQLPLUS utility in Jobcontrol using DSExecute.

HTWH.

Regards
Saravanan

As Kumar suggessted, you can achieve this using Aggregator stage. You can use Max or Sum function to get everything in single row.

Regards
Saravanan

Hi,

If you choose 'clear' option in preserve partitioning, the warning message would disappear.

Set 'APT_DUMP_SCORE' env variable to true, then you should be able to identify what partitions are used in the flow/job by viewing log details of job.

HTWH.

Regards
Saravanan

SID (Service Name) , the server IP address and port have to be mentioned in the TNSNAMES.ORA file, which would be one of the subfolders of the folder, where oracle installed. This would be sufficient to connect to Oracle using OCI stage. ODBC DSN has to be created if you access Oracle DB using ODBC....

If the file is Sequential file, as Arnd mentioned you can use rm/del to delete the file and touch/echo command to create the file again.

You need to check the OS before executing the commands if the code is common for Windows and UNIX.

HTWH.

Regards
Saravanan

Are you able to execute the procedure in the DB environment by using the same id that was used to run SP from DataStage?

Pls check executing the SP and tell us if there is any error.

If it yes, as of my best knowledge you should be able to execute the SP from DataStage as well.

Regards
Saravanan

Hi All, Thanks for your inputs. Hi Ray, The error message is as follows. Compiling: Source = 'DSU_BP/DSU.ttrd', Object = 'DSU_BP.O/DSU.ttrd' * WARNING: Variable 'TestInput' never assigned a value. Compilation Complete. Pls let me know if any of the header file to be included. Hi Benny, I am trying t...