Getting data out of DS_AUDIT
Posted: Tue Mar 01, 2011 5:34 am
Hey folks, I am trying to get the last mod date and the last mod user from DS_AUDIT for a report. The below SQL is what I am using in a server job using an ODBC stage to connect to localuv. The job abends with the message below. I think its because the fields are multivalued and probally very long in some cases. Doees anyone know what options I have to get at this info. I really only want the last sub value. I tried making the column lenght large but that does nto work either
many thanks
Mark :D
DS_JobList1..Transformer_7.DSLink11: DSD.BCIGetNext call to SQLFetch failed.
SQL statement:SELECT INSTANCE, MODIFIER FROM DS_AUDIT
SQLSTATE=S1000, DBMS.CODE=930122
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: Row length exceeds buffer size.
DS_JobList2..Transformer_7.DSLink11: DSD.BCIGetNext call to SQLFetch failed.
SQL statement:SELECT INSTANCE, DTM FROM DS_AUDIT
SQLSTATE=S1000, DBMS.CODE=930122
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: Row length exceeds buffer size.
many thanks
Mark :D
DS_JobList1..Transformer_7.DSLink11: DSD.BCIGetNext call to SQLFetch failed.
SQL statement:SELECT INSTANCE, MODIFIER FROM DS_AUDIT
SQLSTATE=S1000, DBMS.CODE=930122
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: Row length exceeds buffer size.
DS_JobList2..Transformer_7.DSLink11: DSD.BCIGetNext call to SQLFetch failed.
SQL statement:SELECT INSTANCE, DTM FROM DS_AUDIT
SQLSTATE=S1000, DBMS.CODE=930122
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: Row length exceeds buffer size.