i_stevens
Member
Hi All
I have recently downloaded ESU JD10863 for B733.2. One of the SARs (4901666)
has special instructions that I would like to implement.
The SAR indicates that "Because the format of RPPO in F0411 has changed it is
recommended that an SQL statement be written to update all existing records in
F0411 where RPPO is NOT blank and left pad the existing Purchase Order Number
with zeros. The Purchase Order Number (RPPO) field for existing records will
be in the following format '1234'. The SQL statement should update them to look
like this '00001234'."
I initially asked the JDE response line for assistance, but have been told that
it is "against policy" to provide SQL statements to customers.
Being a relative newbie to SQL and it's uses (and it's potential hazards), I was
wondering if somebody out there would be so kind as to email me with the SQL
statement that should be used to achieve this.
Any help would be greatly appreicated.
Thanks
Ian
[email protected]
AS400 720 V4R4M0 Ent Server, NT 4.0 Deployment Server
B7332 co-existence with A7.3 cu 11
View our website at http://www.monadel.com.au
|---------------------------------------------------------------------------|
| |
| If this communication is not intended for you and you are not an|
| authorised recipient of this email you are prohibited by law from dealing|
| with or relying on the email or any file attachments. This prohibition|
| includes reading, printing, copying, re-transmitting, disseminating,|
| storing or in any other way dealing or acting in reliance on the|
| information. If you have received this email in error, we request you|
| contact us immediately by returning this email to|
| [email protected] and destroy the original. |
|---------------------------------------------------------------------------|
B733.2 SP11.1, A73 Cum 11 (Payroll)
Ent Svr AS/400 V4R4, Dep Svr NT4 SP5
I have recently downloaded ESU JD10863 for B733.2. One of the SARs (4901666)
has special instructions that I would like to implement.
The SAR indicates that "Because the format of RPPO in F0411 has changed it is
recommended that an SQL statement be written to update all existing records in
F0411 where RPPO is NOT blank and left pad the existing Purchase Order Number
with zeros. The Purchase Order Number (RPPO) field for existing records will
be in the following format '1234'. The SQL statement should update them to look
like this '00001234'."
I initially asked the JDE response line for assistance, but have been told that
it is "against policy" to provide SQL statements to customers.
Being a relative newbie to SQL and it's uses (and it's potential hazards), I was
wondering if somebody out there would be so kind as to email me with the SQL
statement that should be used to achieve this.
Any help would be greatly appreicated.
Thanks
Ian
[email protected]
AS400 720 V4R4M0 Ent Server, NT 4.0 Deployment Server
B7332 co-existence with A7.3 cu 11
View our website at http://www.monadel.com.au
|---------------------------------------------------------------------------|
| |
| If this communication is not intended for you and you are not an|
| authorised recipient of this email you are prohibited by law from dealing|
| with or relying on the email or any file attachments. This prohibition|
| includes reading, printing, copying, re-transmitting, disseminating,|
| storing or in any other way dealing or acting in reliance on the|
| information. If you have received this email in error, we request you|
| contact us immediately by returning this email to|
| [email protected] and destroy the original. |
|---------------------------------------------------------------------------|
B733.2 SP11.1, A73 Cum 11 (Payroll)
Ent Svr AS/400 V4R4, Dep Svr NT4 SP5