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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 602 views
  • 0 likes
  • 2 in conversation