Search found 86 matches
- Fri Feb 26, 2016 3:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert into Oracle with reserved word
- Replies: 3
- Views: 16808
Insert into Oracle with reserved word
Hello, I am using Oracle connector stage my insert statement have reserved word column DEFAULT..when I run my job it gives me error ORA-01747: invalid user.table.column, table.column, or column specification when I put "DEFAULT" in double quotes it gives me error ORA-01745: invalid host/bi...
- Wed Apr 29, 2015 8:03 am
- Forum: General
- Topic: connect to ds engine
- Replies: 3
- Views: 2951
Thanks Ray, We can increase the Terminal connection but max 10. Since the number of projects are increasing the headcount will eventually increase and each member has to access the server. Remote connection makes more visibility to engine in contrast to command prompt. So we are looking for a third ...
- Tue Apr 28, 2015 8:42 am
- Forum: General
- Topic: connect to ds engine
- Replies: 3
- Views: 2951
connect to ds engine
Like on unix box, we use putty software to connect to Infosphere engine for ETL developers as they need to develop scripts for the projects. DO we have any options for INfoshphere engine installed on Windows 2008 R2. Currently ETL users are doing remote connect and at max 2 people are able to connec...
- Thu Feb 19, 2015 9:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple attributes not coming in xml
- Replies: 2
- Views: 2803
- Wed Feb 18, 2015 4:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple attributes not coming in xml
- Replies: 2
- Views: 2803
multiple attributes not coming in xml
hi, my xml is as follows.. <ComplexXML> <LevelElement> <elementattributes name="level1" col1="a" col2="b" col3="c" > <subelements> <col4="d" col5="e" col6="f"> <col4="g" col5="h" col6="i"> </subelemen...
- Sun Feb 01, 2015 10:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic for Rank generation
- Replies: 12
- Views: 9260
Hi All, I sorted the data on ascending product(PRDNAME) and descending amount and Keychange column is always is giving as 1. Sort stage --------------------- Key =PRDNAME Sort order = Acsending Key=PRDAMT Sort order= Desending Hash Partition = PRDNAME PLease help me whethere iam missing anything to ...
- Wed Jan 14, 2015 3:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date comparsion in transformer
- Replies: 4
- Views: 7002
Date comparsion in transformer
Hi All, I need help in compare two date fields in datastage parallel job transformer stage Both the start date and end date fileds are NULLABLE NO yes fields. Example ================ start date :2015-12-20 End date :2015-09-19 I just want to know whether start is greater than End date in datastage ...
- Tue Dec 23, 2014 7:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic for Rank generation
- Replies: 12
- Views: 9260
- Tue Dec 23, 2014 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic for Rank generation
- Replies: 12
- Views: 9260
- Tue Dec 23, 2014 5:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic for Rank generation
- Replies: 12
- Views: 9260
- Tue Dec 23, 2014 4:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic for Rank generation
- Replies: 12
- Views: 9260
- Tue Dec 23, 2014 12:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence number generation for same group for sources
- Replies: 4
- Views: 3997
- Mon Dec 22, 2014 8:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence number generation for same group for sources
- Replies: 4
- Views: 3997
We can generate number after combining two files source but , how to generate SERIAL values for SOURCE2 . Rule for SERIAL column Generation : Number generation should be started from SOURCE1 starting from 10 and increment by 10 for the records DEPT wise. For SOURCE2 the SERIAL column should start fr...
- Mon Dec 22, 2014 1:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence number generation for same group for sources
- Replies: 4
- Views: 3997
Sequence number generation for same group for sources
Hi All, I need some help to implement below requirement Please find my requirement with above sample example. Iam having two input files "file1" and "file2" comma delimeted file and i need to generate SERIAL column after combining both files. SOURCE 1 ============== DEPT , EMPNO ...
- Fri Dec 19, 2014 4:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TeraData XML datatype
- Replies: 6
- Views: 5872