thanks Ray
Where can i find pre sql option in oracle enterprise stage for truncating existing records and then insert new records
Search found 77 matches
- Thu Sep 15, 2005 3:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle enterprise stage
- Replies: 3
- Views: 2264
- Thu Sep 15, 2005 1:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle enterprise stage
- Replies: 3
- Views: 2264
oracle enterprise stage
hi i have a requirement such that we need to delete existing data on oracle database table and load new data for each job run. what is the best approach where we can do delete and insert operations in the same job flow? i didn't find any of the write options in oracle enterprise stage where we can d...
- Fri Sep 09, 2005 2:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: job is aborted due to before job routine
- Replies: 1
- Views: 1655
job is aborted due to before job routine
hi, i have import all the job designs from Dev to Test environment. i compiled all the jobs in test environment. when i try to run the job, it is giving an error- Before job routine is not working.. error as follows CVPayTerms..BeforeJob (ExecSH): Error when executing command: /apps/Ascential/Projec...
- Wed Sep 07, 2005 6:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: $Projdef
- Replies: 5
- Views: 8130
- Wed Sep 07, 2005 3:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: $Projdef
- Replies: 5
- Views: 8130
$Projdef
Hi, i have read some posts regarding $Projdef project specific env variable. i am not still understanding the use of $Projdef env variable. how to use exactly this variable ? i have created some env variables at dsadmin like $Par_SrcFilePath $Par_TrgFilePath $Par_remoteUserID $SRC_DBNAME etc where s...
- Mon Aug 29, 2005 7:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle enterprise load error
- Replies: 2
- Views: 1867
- Tue Aug 23, 2005 11:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FMT function in parallel transfer
- Replies: 1
- Views: 2116
FMT function in parallel transfer
Hi, i wanted the exact parallel function to format a value. eg:- i need to generate a 6 digit number like FMT(@OUTROWNUM,"6''0'R") "000001" "000002" FMT does not work on parallel transformer and i should not use Basic transformer here for this formatting. is there any p...
- Tue Aug 23, 2005 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle enterprise load error
- Replies: 2
- Views: 1867
oracle enterprise load error
Hi, i am loading the data from source sequential file to oracle database with oracle enterprise stage with Target properties Write Method = Load and Writ Mode = Append. When i try to insert the data it is giving error ORCL_REQ_HEADER,0: SQL*Loader-128: unable to begin a session ORCL_REQ_HEADER,0: OR...
- Mon Aug 22, 2005 12:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: extract data from two different databases
- Replies: 7
- Views: 3991
- Sun Aug 21, 2005 7:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CombinedOperatorController,0: Field 'REGN_I' from input
- Replies: 4
- Views: 2790
- Sun Aug 21, 2005 6:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: extract data from two different databases
- Replies: 7
- Views: 3991
i have extracted MAX(LAST_EXT_ID) from first job and how to pass that value as a parameter to the second job's query where i need to do filter condition like this SELECT A.INDATE,A.PRJNAME,B.SRID FROM PRIME.PROJECT A, PRIME.SECTION B, A.PRJID = B.SRID AND A.PRID > #PARAMETER# can anybody help me out...
- Sun Aug 21, 2005 6:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: transforms need to replace OConv and FMT
- Replies: 5
- Views: 4451
- Sun Aug 21, 2005 5:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CombinedOperatorController,0: Field 'REGN_I' from input
- Replies: 4
- Views: 2790
- Sat Aug 20, 2005 12:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CombinedOperatorController,0: Field 'REGN_I' from input
- Replies: 4
- Views: 2790
APT_CombinedOperatorController,0: Field 'REGN_I' from input
Hi, i am getting the following error APT_CombinedOperatorController,0: Field 'REGN_I' from input dataset '0' is NULL. Record dropped. source is DB2 and field REGN_I data type is varchar, it contains Null values. source is extracting the data correctly, but at the time of transformation , it is trunc...
- Fri Aug 19, 2005 9:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: extract data from two different databases
- Replies: 7
- Views: 3991