RE: [sqr-users] PeopleSoft SQR question

["Aguirre, Jose" <JAguir@lsuhsc.edu>]

You can try giving the variable an edit mask:  edit 9999999.99.  But if the 
input flat file dollar value does not have a decimal - when inserting into the 
DB -  it should put the decimal of .00.



José A. Aguirre

-----Original Message-----
From: sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org 
[mailto:sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org] On Behalf Of Hall, Tara
Sent: Monday, November 06, 2006 8:09 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] PeopleSoft SQR question

Hi,

I have an sqr that is reading a flat file and populating a table.  I'm 
encountering an issue with the handling of a dollar amount.  The last two 
digits should be the cents amount.  However, I can't determine where the 
dollars and cents are being manipulated in the process.  My short term fix was 
to change the field positions to get the correct dollar amounts.  This only 
works because in this particular flat file there are no dollar amounts with 
cents.

Any suggestions.

Thanks.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users