Hi.
Is it possible to write to an Oracle table thats name is longer than 32 Char? I am able to read it using SQL Passthrough as suggested in several other threads, but when I try to insert some rows, i get...
"ERROR 65-58: Name 'WP_MARKETINGPROMOTIONSELIGIBILITY_BKUP' is too long for a SAS name in this context."
I am using the code below. Am I missing something, or is writing not possible?
data test;
input cardcode $ promoid took $ segmentatdrop $ presented $ presenteddate presentedby;
cards;
S123456 3000 N Fringe Y . 999
S123457 3000 N Fringe N . 999
S123458 3000 N Fringe N . 999
run;
proc sql;
connect to odbc as myconn (datasrc=Prod user=sas password="edited" readbuff=3000);
insert into WP_MarketingPromotionsEligibility_bkup (cardcode, promoid, took, segmentatdrop, presented, presenteddate, presentedby)
select * from test;
disconnect from myconn;
quit;
Thanks!
Your insert into is not in a PASSTHRU step:
proc sql;
connect to odbc as myconn (datasrc=Prod user=sas password="edited" readbuff=3000);
execute (
insert into WP_MarketingPromotionsEligibility_bkup (cardcode, promoid, took, segmentatdrop, presented, presenteddate, presentedby)) by myconn;
disconnect from myconn;
quit;
Your insert into is not in a PASSTHRU step:
proc sql;
connect to odbc as myconn (datasrc=Prod user=sas password="edited" readbuff=3000);
execute (
insert into WP_MarketingPromotionsEligibility_bkup (cardcode, promoid, took, segmentatdrop, presented, presenteddate, presentedby)) by myconn;
disconnect from myconn;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.