DSXchange

thanks ds_developer

Hi , i am getting warning error as foloows. Cannot insert explicit value for identity column in table 'nsar' when IDENTITY_INSERT is set to OFF. what does it mean nsartable..Transformer_1.DSLink17: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO uci.dbo.nsar(nsar_id, total_net_assets...

hi ray,

the format is right.

i need something that genearte seconds after decimal

for example like this 2005-05-19 12:03:45.256

hi craig

I am loading data from sequential fiel to odbc, when i view the data from

databrowser i can able to see the input data ,


why it is saying for evry field that is mapping from input as 'null' (warnings)

if u have any idea please let me know
thanks

hi all, i am getting following warning. after 50 warninngs my job is aborting nsartable..Transformer_1.DSLink17: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO uci.dbo.nsar(nsar_id, total_net_assets, change_in_tot_assets, foreign_exposure, diversified_fund, open_end_fund, fund_name,...

hi all; this is my run time error Ldnavtable..Transformer_1.DSLink5: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO uci.dbo.nav(account_id, eff_start_dt, nav, eff_end_dt, created_dtm, created_by, last_upd_dtm, last_upd_by) VALUES (?,?,?,?,?,?,?,?) SQLSTATE=S1000, DBMS.CODE=0 [DataSt...

Thank you arndw,

you are ryt , my dba has changed its data type in the target . i don't know that.

Hi all , my job is aborted , field sql type length scale input nav decimal 18 2 target is sql server nav numeric 15 2 i got follwing first warning. Ldnavtable..ODBC_2.DSLink4: DSD.BCIOpenW results of SQLColAttributes(nav) gave MetaData mismatch COLUMN.TYPE Expected = Numeric Actual = Integer what mi...

Hi all, in the out put i need to generate current timestamp . the format is like this yyyy-mm-dd hh:nn:ss.x whre x represents 3 digits of current time micro seconds i am suing OCONV(DATE(), "D4-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS:") : ".000" but it is wron...

Hi in my input file CIK is one of the fields ,its length is 10, sql type is integer dataformat is 0000004567 (example) In out put file CIK is one of the fields its length is 8, sqltype is varchar . if it's length is 8 it will truncate the data. i think my job is getting aborted because of above reas...

thanks sainath my target database is sqlserver, for target i am using ODBC stage. the input and output columns are matching except their length. for 1st warning i am getting the following message. nsartable..Transformer_1.DSLink11: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO uci....

Hi sainath


i tried using sequential file in the target;(dslink3 is input to transformer)

i am getting floowing error

textfile..Sequential_File_0.DSLink3: read_delimited() - invalid quotes, column FUND_NAME = "DOGS"


what does it mean

thanks

Hi all; my job is aborting after 50 warnings . nsartable..Transformer_1.DSLink11: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO uci.dbo.nsar(nsar_id, total_net_assets, change_in_tot_assets, foreign_exposure, diversified_fund, open_end_fund, fund_name, borrowing_name, cik, as_of_dat...

Hi all; i have input field "DATE" in the format mm/dd/yyyy output i need "DATE" in the format yyyy-mm-dd 00:00:00.000 i am using following format , but it is giving syntax error(showing red); Oconv(iconv(DSLink3.DATE,'' D/MDY[2,2,4]") ,"D-YMD[4,2,2]") :" 00:00...

Thank you kris,