473,386 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

SQLDA max length for sqlname

Hi,

We are using some tables with descriptive names, for which the columnnames can become larger than 30 characters.
In our programs (ILE RPG: Exec SQL describe sqlExtract into :sqlda using NAMES) we use the SQLDA to get column information.
However, we found that the sqlname in the SQLDA is VARCHAR(30), and thus truncating the longer columnnames.
Is there another way to get around this limit?

Best regards,
-Arco
Jan 18 '12 #1
0 1470

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Mitchua | last post by:
Simplified a bit, I'm parsing HTML documents to get sentences e.g. my $html = get($URL); # remove all HTML TAGs...blah blah blah @sentences = split(/\./, $html)); then I'm trying to determine the...
0
by: tom | last post by:
I am new to DB2. I do not know how to set the SQLDA variables. I am using SQR through Brio to select a CLOB field from a table. I have read the examples for C programs using prepare from and...
1
by: Rob | last post by:
I'd like to be able to identify IDENTITY columns via the SQLDA. Looking up the DESCRIDE TABLE statement in DB2 OS/390 Ver7.1 SQL Reference doesn't mention that the SQLDA will contain any...
4
by: randomtalk | last post by:
hello, I'm doing an exercise in "The C Programming Language, Second Edition". I just can't get one of the first chapter problem correct (I do realize however that there are answer exist on the...
1
by: Sathyaish | last post by:
I have the following scenario: Algorithm: 3DES Cipher Mode: CBC Key Size: 128-bit Block Size: 64 bit IV: 0x0000000000000000 (an eight byte array of zeros) The results I get using .NET with...
9
by: weirdwoolly | last post by:
Hopefully someone will be able to help. I have written a stored procedure in C++ called from a Java test harness to validate the graphic data types in C++ and their use. I have declared the...
14
by: Richard Maher | last post by:
Hi, Can anyone please show me a regular expression (or function or other) for padding out a string to a fixed number of bytes? At the moment I've got a var initialized to N spaces, where 'N'...
2
by: Parnamwulan | last post by:
Hello guys, Pls dont laugh - it is not funny (actually it is, but it is causing me problems) I have problem with SQLDA data type specification. I need to create some counted columns, so I...
11
by: rote | last post by:
I'm getting the email address from an excel sheet. But i need to send the email to multiple people When printing the below i get a@a.com;b@b.com;; But i want a@a.com;b@b.com; i don't need...
1
by: shorti | last post by:
I am using DB2 UDB V8.2 on AIX. We recently added some VARCHAR fields into our database and I found an issue with how we are reading data when retrieving it into an sqlda structure using dynamic...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.