BookmarkSubscribeRSS Feed
Bipasha
Obsidian | Level 7

I am accessing Oracle table using SAS federation server. Some of my SAS Federation Server tables have columns with length 4000. Don't know how exactly that happened. I need to extract some data out of the tables including some fields having length 4000 or more.

 

My extract tool gives the following error:

 

ERROR: CLI prepare error: Column "XYZ" not found or cannot be accessed

 

I found out that column XYZ has length 4000. That can be the cause of the error.

 

Can anybody help to Identify the problem and solve it?

 

 

1 REPLY 1
LinusH
Tourmaline | Level 20

I'm not sure if I following your.

Are you using DI Studio to access Oracle data via a Federation Server library?

 

First, does it work in Federation Server (without eror)?

Have you tried to change the columns definition in Federation Server to match the actual lengths?

If not, I suggest that you open a ticket to SAS tech support so they can guide you through.

Data never sleeps

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 640 views
  • 0 likes
  • 2 in conversation