MVSFORUMS.com

WORKER-ANT · Beginner Joined: 13 Aug 2004 Posts: 4 Topics: 1

all i can find on this message is that 'Date or timestamp value adjusted.' Can any one give advise why this message is reported and solutions to prevent it reporting please.

many thanks
Antony

kolusu · Posted: Fri Aug 13, 2004 7:22 am Post subject:

Worker-ant,

What is the sqlstate from the query ? Can you post your output which is something like this ?

WORKER-ANT · Beginner Joined: 13 Aug 2004 Posts: 4 Topics: 1

Kolusu

DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
DSNT418I SQLSTATE = 01004 SQLSTATE RETURN CODE
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'...
INFORMATION
DSNT417I SQLWARN0-5 = W,W,,,, SQL WARNINGS
DSNT417I SQLWARN6-A = ,,,, SQL WARNINGS
SELECT SUCCESSFUL

select statment same as
select * from tableA;
the above warning is issued for each row on the table

many thanks

kolusu · Posted: Mon Aug 16, 2004 7:57 am Post subject:

Worker-ant,

The sqlstate of 01004 is can occur if the value of a string was truncated when assigned to a host variable. So check the host variable declaration and make sure that they are compatible to the db2 table column definition.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

WORKER-ANT · Beginner Joined: 13 Aug 2004 Posts: 4 Topics: 1

Thanks Kolusu, there are however no host variable concerned here as it is a Spufi querying the db. I thought that may be db2 was able to recognise a data imperfection on the table and was correcting it before displaying the output. the imperfection created by data load from one table to another. feasible do you think? perhaps the source table has a different definition of field than the target table (which is the table queried here ) I will make enquiries on this thanks again

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

On the options panel for SPUFI you have the possibility to define a maximum displayable length for character columns. Perhaps your installation provides you with a length shorter than 26.

regards
Christian

WORKER-ANT · Beginner Joined: 13 Aug 2004 Posts: 4 Topics: 1

Thanks Christian, i had a look at the column defs for the table and one col is a masssive varchar which i think would go with Kolusus' truncated reason. the spufi was run in batch which as far as iknow has no installation limits except the output size when output is wrapped to suit. there could be a setting somwhere that prevents wrapping in excess. thanks for your interest.

Antony