MVSFORUMS.com

[naren_ab]

In a C pgm how do i define DB2 host variable say name of length 20.
In Db2 table name is defined as Char of length 20.
SO i tried char name[20] in C but it gives error saying undefined or unusable host varibale.

Let me know if you have answer

[DaveyC]

DB2 adds 1 to all C char buffers for the NULL terminator (even if it's not a string). If you use the DCLGEN utility you should have no problems.
_________________
Dave Crayford

[naren_ab]

Thanks you Dave,
But >
declgen created the name field as
char NAME 41Y; and when I compile, I get UNDEFINED OR UNUSABLE HOST VARIABLE "NAME". so I changed it to "char NAME;" it made to work fine. Since char is only 1 byte i am getting onyl the 1st character of name in NAME field.

How do i solve it. I cannot declare NAME as array, as DB2 will not know it.

[kolusu]

Naren,

How about defining like this ???

[naren_ab]

Hurray! it works. but would request you to explain about it, and where can i find more on the same.
Thanks once again Kolusu

[kolusu]

Naren,

I just ran DCLGEN in batch for one of my existing table.DCLGEN generates the approriate language declarations.

[naren_ab]

I have used spufi to create the DCLGEN. But where did you see this syntax
"char NAME??(20??) " what does "??" mean?

[kolusu]

Naren,

There is a seperate option for DCLGEN on DB2I panel. option 1 is spufi and option 2 is DCLGEN. once you run the dclgen initially you will see the table declaration and if you scroll down you will find the approriate language declarations below.The links posted above explains clearly the DCLGEN for both batch and interactive

Why dont you run the sample jcl I provided above and check out the include in your pds ??

Kolusu

[DaveyC]

??( is called a trigraph. The problem is the DB2 pre-compiler doesn't recognise the locale you are using (I think it uses 1047). I run a translation program before the DB2 precompile