I have chosen PL/SQL block in the options and executed the insert and then update sql.
I have tested it, and it works fine.
Do you think this could cause any unknown issues later down the road.
Search found 74 matches
- Thu Apr 30, 2015 11:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stage Dependency
- Replies: 3
- Views: 2476
- Sun Apr 26, 2015 2:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stage Dependency
- Replies: 3
- Views: 2476
Stage Dependency
Hi Can I have Dependency on Stages within Datastage Job instead of Sequence ? For instance, I wan to run update/insert query on two tables, but they have to be performed one after the other with same dataset. Do I have to go for the sequence for this functionality? Is there a way that I can implemen...
- Mon Sep 08, 2014 9:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: junk character removal
- Replies: 17
- Views: 10408
- Sun Sep 07, 2014 2:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warnings C++ code
- Replies: 0
- Views: 2408
warnings C++ code
Hi, I have written a C++ program, while compiling the code I am getting the below error. Can you please help me identify the problem. ##W IIS-DSEE-TBLD-00000 19:58:13(004) <main_program> When checking operator: Output from subprocess: ld: 0711-224 WARNING: Duplicate symbol: std::out_of_range::_Dorai...
- Sat Aug 30, 2014 1:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: junk character removal
- Replies: 17
- Views: 10408
- Sat Aug 16, 2014 10:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: junk character removal
- Replies: 17
- Views: 10408
- Thu Aug 14, 2014 7:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: junk character removal
- Replies: 17
- Views: 10408
- Wed Aug 13, 2014 1:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: junk character removal
- Replies: 17
- Views: 10408
- Sun Aug 10, 2014 11:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: junk character removal
- Replies: 17
- Views: 10408
- Sun Aug 10, 2014 11:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: junk character removal
- Replies: 17
- Views: 10408
Convert(Char(0):Char(1):Char(2):Char(3):Char(4):Char(5):Char(6):Char(7):Char(8):Char(9):Char(10):Char(11):Char(12):Char(13):Char(14):Char(15):Char(16):Char(17):Char(18):Char(19):Char(20):Char(21):Char(22):Char(23):Char(24):Char(25):Char(26):Char(27):Char(28):Char(29):Char(30):Char(31):Char(127):Cha...
- Thu Aug 07, 2014 7:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: junk character removal
- Replies: 17
- Views: 10408
junk character removal
Hi I am trying to remove all junk characters from source data on every field. To achive this I am removing Characters 0-8, 10-31, 127-255 using convert function: Convert(Char(0):Char(1):Char(2).........etc,"",InputField) But I see that from some of the fields the spaces are getting removed...
- Tue Aug 05, 2014 9:17 pm
- Forum: General
- Topic: Decimal format
- Replies: 5
- Views: 2702
- Tue Aug 05, 2014 11:58 am
- Forum: General
- Topic: Decimal format
- Replies: 5
- Views: 2702
- Tue Aug 05, 2014 6:53 am
- Forum: General
- Topic: Decimal format
- Replies: 5
- Views: 2702
Decimal format
Hi,
I am slightly confused with decimal format. Can you please clarify the below to me.
DECIMAL[1,0]
Maximum Value = 9.0
Minimum Value = -9.0
DECIMAL[5,2]
Maximum Value = 999.99
Minimum Value = -999.99
Am I right over here?
I am slightly confused with decimal format. Can you please clarify the below to me.
DECIMAL[1,0]
Maximum Value = 9.0
Minimum Value = -9.0
DECIMAL[5,2]
Maximum Value = 999.99
Minimum Value = -999.99
Am I right over here?
- Tue Aug 05, 2014 6:50 am
- Forum: General
- Topic: datastage log with C++
- Replies: 3
- Views: 2001