BookmarkSubscribeRSS Feed
Cherry
Obsidian | Level 7

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';


data sample;

set min.sale_30(keep=ip_id_cust obs=100);

run;


%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

dbcommit=100000)

data = sample;

run;

quit;

Error Message:

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.

5 REPLIES 5
Doc_Duke
Rhodochrosite | Level 12

my guess is that the macro variables in your TEMP LIBNAME are not resolving the way they did before.  Try

OPTIONS MPRINT:

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).

Doc Muhlbaier

Duke

Cherry
Obsidian | Level 7

Hi,

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?.

Tom
Super User Tom
Super User

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.

ChrisHemedinger
Community Manager

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.


Chris

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
Ksharp
Super User

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/';

Ksharp

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1923 views
  • 3 likes
  • 5 in conversation