First, this is a question probably better suited to midrange-l@xxxxxxxxxxxx

Having said that, can you explain the point of the char(10) in the
statement. The select seems to be building a string, but I'm not sure where
the char(10) comes into play. What are you trying to do?

-Walden

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: Caroline Wanyonyi [mailto:Caroline.Wanyonyi@xxxxxxxxxx] 
Sent: Monday, November 10, 2003 4:23 PM
To: mi400@xxxxxxxxxxxx
Subject: [MI400] AS400 script problem with char(10)

Hi,

I'm trying to run this statement in AS400 and I keep getting an error,
specific with the char(10). Does anyone know what I need to change the
char(10) to work?

SELECT 
   'while [ "$tryexport" = "true" ]; do',char(10),
   '  eval ${SIEBEL_HOME}/bin/dataexp /u &3 /p &4 /c &5 /d &2 /f
${DATA}/'||NAME||'.dat /i ${DATA}/'||NAME||'.inp /q 1000 /l
${DATA}/'||NAME||'_exp.log >> nul',char(10),
   '  validate $? '||NAME,char(10),
   '  if [ "$tryexport" = "false" ]; then',char(10),
   '     tryexport=true',char(10),
   '     break',char(10),
   '  fi',char(10)||
   'done',char(10)
FROM 
   &2.S_TABLE

Your assistance is highly appreciated!
Thanks,
Caroline

_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.