MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 4 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: DSNT417I SQL Warning Message during SELECT statement
WORKER-ANT

Replies: 6
Views: 9862

PostForum: Database   Posted: Tue Aug 17, 2004 9:43 am   Subject: DSNT417I SQL Warning Message during SELECT statement
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 ikno ...
  Topic: DSNT417I SQL Warning Message during SELECT statement
WORKER-ANT

Replies: 6
Views: 9862

PostForum: Database   Posted: Mon Aug 16, 2004 8:51 am   Subject: DSNT417I SQL Warning Message during SELECT statement
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 i ...
  Topic: DSNT417I SQL Warning Message during SELECT statement
WORKER-ANT

Replies: 6
Views: 9862

PostForum: Database   Posted: Mon Aug 16, 2004 1:55 am   Subject: DSNT417I SQL Warning Message during SELECT statement
Kolusu

DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
DSNT418I SQLSTATE = 01004 SQLSTATE RETURN CODE
DSNT416I SQLERRD = 0 0 ...
  Topic: DSNT417I SQL Warning Message during SELECT statement
WORKER-ANT

Replies: 6
Views: 9862

PostForum: Database   Posted: Fri Aug 13, 2004 4:57 am   Subject: DSNT417I SQL Warning Message during SELECT statement
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
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group