DSXchange

I searched the forum and got this command to initialize a Sequence_name . UPDATE SDKSequences USING DICT VOC SET F1 = 'New_Value' WHERE @ID = 'Sequence_Name'; I have set of Sequence_Names to initialize at a time before starting data load process. How can i update set of Sequence_Names at once ? We h...

Thank You
Paddu

i tried this


CALL smdmadm.CHECK_DIM_NULL_VALUE();

CALL smdmadm.CHECK_MISSING_KEY_VALUE();

looks like first procedure exectued . i could see data popluated in the table but i don't see second one executed.

I got thsi warning again
ORA-00900: invalid SQL statement

Thanks
Paddu

Hi

call smdmadm.CHECK_MISSING_KEY_VALUE() worked .Thanks :D

How can i Exec two procedures one after the other ? Shall i use semi-colon at the end of the statement?

Thank You Very Much
Paddu

I am trying to execute a store procedure using Oci stage After Sql as Exec smdmadm.CHECK_MISSING_KEY_VALUE It give me this error. ORA-00900: invalid SQL statement can anyone help me out with this. Thsi procedure pulls all the table names , column names , count in that particular schema (smdmadm) and...

resolved this issue . The issue was with AVG columns . I used round function in my sql query to get rid of decimal place after 5 and it worked fine. You all were right ,data was not fitting into datastage data definintion. Thanks Now i have new issue . We have 20 job sequences . All are put together...

[quote="ray.wurlod"]No, you can still form a sum or an average even though some of the values are non-positive. Nulls might cause an issue, but you can extract these using the NVL function. No, it's not that. ...[/quote] Ray , i tried using NVL but same error . The same query works fine in...

Ray,

it runs fine in Toad , i even checked the max count of the sum of columns
it does not exceed the limit .

but few columns which i summing and doing AVG have zeros or negative values mostly, Does this affect?



Thanks
paddu

Hi all i am perfoming aggregation on certain columns and it throws me this warning and aborts ( does not show warning at which record but almost for all the records) DIRECT_SALES_test_2006913..tf_ORDERTYPE: OCI has fetched truncated data Size of the table 8Million My aggregation is through SQL query...

Hi All, i am reading a Flat File (pipe delimited) and writing into Oracle. i see the warning below for about 5 times and my job aborts. nls_map_buffer_in() - NLS mapping error, row 1812940 (approx), row = "0106390580|000010||EA|||52138Z||20060116||00000000|24.000 |24.000 |24.000 |0120|00001|EA|...

Yes Craig , I am fine now

Thanks
Paddu

I used this before but i realised i was doing something which makes no sense. OCONV(ICONV(out_BURT_TOT.DATEFROM[1,4]:"-":out_BURT_TOT.DATEFROM[5,2]:"-":out_BURT_TOT.DATEFROM[7,2] : " " : out_BURT_TOT.ABIC_ZSTARTIME[1,2]:":":out_BURT_TOT.ABIC_ZSTARTIME[3,2]:&qu...

I tried what you gave kris but now it does not convert and nulls are not accepted in thisfield. Individual pieces work fine Date conversion and Time conversion but concatenate does not work . Is there any function to convert the whole logic to convert to orcale timestamp. Any help appreciated Thanks...

No change in the error message ORA-01830: date format picture ends before converting entire input string :( OCONV(ICONV(Arg1[1,4]:"-":Arg1[5,2]:"-":Arg1[7,2],"D-YMD[4,2,2]"),"D-YMD[4,2,2]") : " " : OCONV(ICONV(Arg2[1,2]:":":Arg2[3,2]:"...

Kris- i tried your logic , it threw the same error.

Craig- I did not follow you exactly . Is there any function to convert the whole function which i am using to convert to Oracle Timestamp format ?