DSXchange

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.

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...

I am not able to find similar function in 8.1

do you think I can construct something using OR_BITS

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...

Hi Ray,

Is there any way to remove those Extended EBCDIC character, since char(164,@TRUE), cannot be used in 8.1

Hi Ray,

I am unable to compile as well in 8.1

Hi Ray,

I did try it Ray, but the derivation field was showing up as not valid.

Hi Ray,

I am using Datastage 8.1, looks like there is no second option in the char() function.

While debugging I found that the issue is occurring when I am trying to remove extended ascii characters i.e starting values 128 till 255.

Do we have to use any other function for such values ?

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...

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...

So in my case, are the highlighted one's the correct values
DECIMAL[1,0]
Maximum Value = 9.0
Minimum Value = -9.0 OR Minimum Value = 0.0

DECIMAL[5,2]
Maximum Value = 999.99
Minimum Value = -999.99 OR Minimum Value =-99.99

Does the first argument include or exclude the sign.
DECIMAL[1,0]
Maximum Value = 9.0
Minimum Value = -9.0 OR Minimum Value = 0.0

DECIMAL[5,2]
Maximum Value = 999.99
Minimum Value = -999.99 OR Minimum Value =-99.99

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?

Thank You