DSXchange

Hi
Is there any command for identifying and deleting orphaned datasets ( datasets whose descriptor files have been deleted) ?

Thanks.

It is quite Interesting, My solution would be: If your File is going to be Uniform as u mentioned, with sme structure all along, Use sed command to organise it as follows: Case 11 Date1 = <value> date2 = <value> i.e concatenation of each 3 rows in a single row. Then Read it as a sequential file and ...

Is it possible to read a timestamp field having the following format in a sequential file (parallel job) using the SQL Type as timestamp?



Format: mm/dd/yyyy hh:mm:ss AM/PM

Hi I have set $APT_ORAUPSERT_COMMIT_ROW_INTERVAL=1000000000 in a fact load job that typically handles volumes of 100,000. The idea is to do a database commit after all the records are inserted. If the job aborts, Oracle should do a rollback. However, I find that the inserted records are getting comm...

We have just upgraded from datastage (PX) 7.0 to 7.0.1 . There is a job thats working fine on 7.0 but when we try to run it on 7.0.1 it gives the following Fatal error and aborts

main_program: Fatal Error: index arg (3) exceeds count: 3"

Any pointers on what could be the possible reason.

We have just upgraded from datastage (PX) 7.0 to 7.0.1 . There is a job thats working fine on 7.0 but when we try to run it on 7.0.1 it gives the following Fatal error and aborts

main_program: Fatal Error: index arg (3) exceeds count: 3"

Any pointers on what could be the possible reason.

Hi, I have a Job where I am reading Data From the Dataset, and a Copy Stage sends data across 3 separate Links with sort stage followed by a dataset. Input data has 20 columns and for processing 20 rows the Job is taking almost 3-4 minutes. It seems to be issue with Copy Stage. When I observed throu...

I am trying to read a COBOL file through a sequential file in Datastage (7.0). It has few Signed Decimal Fields ( PIC S9(7)V9(2) ). When I read it through sequential file Stage ( Parallel Job Ver 7.0) it was giving some arbitrary values. When we tried samething with the CFF Stage in Server Job we ar...

Is it possible to split a Dataset through Unix and use the split files as inputs to a DataStage PX Job ?

if so, what are the precautions that one needs to take ?

For the below mentioned approach, let say I extract and create a seq file of 65 million records. I do not have a process lookup. This file is an input to my process transform with the limitation that I do not have a staging area. So My process transform needs to create a load file. When processing t...

For the below mentioned approach, let say I extract and create a seq file of 65 million records. I do not have a process lookup. This file is an input to my process transform with the limitation that I do not have a staging area. So My process transform needs to create a load file. When processing t...

How do we go about using these routines (DATATYPEPICCOMP3xxx )?
Is it possible to use it with parallel jobs? or only with server jobs ?

1) Can PL/SQL procedures on Oracle Database (that have a return value) be called from DataStage ? Would I need an ODBC driver ? 2) If the answer to Question 1 is "NO", can I make a call to a ProC function which in turn calls the PL/SQL procedures ? 3) Are there alternative solutions ? Woul...

Would Datastage process files containing fields with Binary Packed Decimal data? The file type can be Mainframe extracts or CSV Files.

An excel file to be processed has information in several tabs. The need is to read data from two of the tabs. Is it possible to do that using datastage? If not, can you recommend a solution ?