When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
No Answer is Posted For this Question
Be the First to Post Answer
What would be the next step after collecting the data?
Within a cursor, how would you update fields on the row just fetched?
What is the significance of ‘mp run’ command ?
i have input like this TABA 1 TABA 2 TABA 3 TABA 4 TABB 7 TABB 8 TABC 1 TABC 2 TABC 5 OUT PUT NAME COL1 COL2 COL3 COL4 TABA 1 2 3 4 TABB 7 8 TABC 1 2 5
Do we really work with ACTUALDATA in development phase.
How to get DML using Utilities in UNIX?
What is the language used in Ab Initio ?
Mention what are the different types of parallelism used in abinitio?
What is the difference between a utility and api in a RUN SQL component
One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
How would you find out whether a sql query is using the indices you expect?