Re: Embedded and %TIME

["Neil Taylor" <northfields@xxxxxxxxxxxxxx>]

Yes, I thought that would fix it, but it didn't seem to make any difference.


On 10/04/2008, MKirkpatrick@xxxxxxxxxxxxxxxxx <
MKirkpatrick@xxxxxxxxxxxxxxxxx> wrote:
> Check out the SET OPTION TIMSEP
>
>               .-,------------------------------------.
>               V                                      |
> > > -SET OPTION----+-ALWBLK = --alwblk-option---------+-+--------><
>                 +-ALWCPYDTA = --alwcpydta-option---+
>                 +-CLOSQLCSR = --closqlcsr-option---+
>                 +-CNULRQD = --cnulrqd-option-------+
>                 +-COMPILEOPT = --compile-option----+
>                 +-COMMIT = --commit-option---------+
>                 +-DATFMT = --datfmt-option---------+
>                 +-DATSEP = --datsep-option---------+
>                 +-DBGVIEW = --dbgview-option-------+
>                 +-DECMPT = --decmpt-option---------+
>                 +-DECRESULT = --decresult-option---+
>                 +-DFTRDBCOL = --dftrdbcol-option---+
>                 +-DLYPRP = --dlyprp-option---------+
>                 +-DYNDFTCOL = --dyndftcol-option---+
>                 +-DYNUSRPRF = --dynusrprf-option---+
>                 +-EVENTF = --eventf-option---------+
>                 +-LANGID = --langid-option---------+
>                 +-MONITOR = --monitor-option-------+
>                 +-NAMING = --naming-option---------+
>                 +-OPTLOB = --optlob-option---------+
>                 +-OUTPUT = --output-option---------+
>                 +-RDBCNNMTH = --rdbcnnmth-option---+
>                 +-SQLCA = --sqlca-option-----------+
>                 +-SQLCURRULE = --sqlcurrule-option-+
>                 +-SQLPATH = --sqlpath-option-------+
>                 +-SRTSEQ = --srtseq-option---------+
>                 +-TGTRLS = --tgtrls-option---------+
>                 +-TIMFMT = --timfmt-option---------+
>                 +-TIMSEP = --timsep-option---------+
>                 '-USRPRF = --usrprf-option---------'
>
>
>
>
> rpg400-l-bounces@xxxxxxxxxxxx wrote on 04/10/2008 09:42:45 AM:
>
> > Hello
> >
> > I have a question that I hope some one can help with please.
> >
> > I have a procedure in a service program that has input parameter of type
> > TIME
> >
> > When called from a standard RPG module, the time arrives in the format
> > '17:33:00'. It is then happily written to a file.
> >
> > However, I have written a new RPG module with embedded SQL. After the
> SQL,
> > the same procedure is called, but now the time has arrived in the format
> > '17.33.00' and refuses to be written to the file.
> >
> > I have tried assorted tactics, but I can't see an obvious solution.
> >
> > I'd be very grateful if anyone could help.
> >
> > Regards
> >
> > Neil
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
>
>
>
>
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are
> addressed.  Unless you are the addressee (or authorized to receive for the
> addressee), you may not use, copy or disclose to anyone this email or any
> information contained in this email.  If you have received this email in
> error, please advise the sender by replying to this email, and delete this
> email immediately.  Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of Western Dental Services, Inc.  Finally, the recipient should check this
> email and any attachments for the presence of viruses. Western Dental
> Services, Inc. accepts no liability for any damage caused by any virus
> transmitted by this email.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.