08-26-2011 05:56 AM
The code ran successfully on PC sas 9.1 remote submitting to Unix ,where as it is throwing error while running it on EG 4.3 remote submitting to Unix, while uploading a file on to DB2. Can anybody assist me.
libname temp db2 user=&dpwuscod. using=&dpwpwcod. db=&dpwdbnam. schema=temp;
libname min '/user/analytics/projects/2011/BR_2011/Test';
set min.sale_30(keep=ip_id_cust obs=100);
%let prefix = %upcase(%sysfunc(compress(&dpwuscod., "'"'"')))_;
proc datasets nolist force;
append base= temp.sample2
(bulkload=yes bl_load_replace=YES bl_method=cliload bl_recoverable=NO
data = sample;
ERROR: CLI execute error: [IBM][CLI Driver][DB2/AIX64] SQL3025N A parameter specifying a filename or path is not valid.
NOTE: There were 1 observations read from the data set WORK.SAMPLE.
NOTE: The data set TEMP.SAMPLE2 has 0 observations and 1 variables.
ERROR: [IBM][CLI Driver][DB2/AIX64] SQL3025N A parameter specifying a filename or path is not valid.
Results for CLI LOAD operation:
0 rows loaded.
0 rows skipped.
0 rows rejected.
0 rows deleted as duplicates.
0 rows committed.
08-26-2011 05:36 PM
my guess is that the macro variables in your TEMP LIBNAME are not resolving the way they did before. Try
so you can see them.
Are you using an autoexec.sas file on your pure unix runs? It will not be picked up automatically in the EGuide interface. You would need to run it explicitly with the EGuide code (you can do it in tools --> options).
08-30-2011 02:53 AM
1.I have tried as per your advise, macro variables are resolving correctly,
2.Ran autoexec.sas explicitly as per your suggestion.
But still getting the same error. Any other advise?.
08-30-2011 03:31 PM
The EG programm will be submitted to a SAS server. Most likely the SAS server is not setup properly to access the DB2 database. If access to DB2 is anything like access to Oracle there are probably environment variables or search paths that need to be set in the unix shell before the server is launched.
09-07-2011 11:04 AM
I second this response. EG is connecting to a SAS Workspace Server, as configured in SAS Management Console. It's possible that the command/script/options are different/incomplete for this configuration, when compared to those option that you had previously set for a SAS/CONNECT session.
08-30-2011 11:53 PM
I am not quit sure. But your libname statement should be:
libname temp db2 user=&dpwuscod. password=&dpwpwcod. dsn=&dpwdbnam. schema=TEMP;
libname min v9 '/user/analytics/projects/2011/BR_2011/Test/';