Link to home
Start Free TrialLog in
Avatar of ezee
ezee

asked on

db fetch limitations for 255 columns

Hi,
    I am using db fetch for accessing data from the database, in bulk, but when my table has more than 255 columns, bulk fetch neglects the remaining columns abnd fetched only 255 of them. please advice. these are experimental data and there are no other ways except to have them in single tables.

regards
ks
Avatar of AndyAinscow
AndyAinscow
Flag of Switzerland image

Can you split the fetching into 2 (3...) batches?  Each with less than 255 columns?
Avatar of ezee
ezee

ASKER

then i will have trouble putting them together as there is no common primary ket column or anything. is this a real limitation in the odbc part or the db fetch part?
please advice.

tnx
ks
Administrative Action - Force Accepted.

SpideyMod
Community Support Moderator @Experts Exchange
ASKER CERTIFIED SOLUTION
Avatar of AndyAinscow
AndyAinscow
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial