SQL0204 error for LPAD

Tags:
AS/400
SQL
STRSQL
Hi
I am trying to LPAD in STRSQL and getting below error.
Type LPAD N * in * LIBL not found.
Same SQL is running successfully on another server. Can anyone help me on this?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • CharlieBrowne

    Are both machines on the same release leave?

    Is the LIBL set the same on both machines?

    62,385 pointsBadges:
    report
  • pdraebel
    SQL is made up of rules that software vendors can or cannot incoorporate in their version of SQL. The LPAD function may not be available in SQL for all Operating systems.
    7,545 pointsBadges:
    report
  • philpl1jb
    Is LPAD the problem or is it failing to find some other part of your statement .. like a file?
    54,090 pointsBadges:
    report
  • ToddN2000
    Can you provide more info like what SQL versions and OS release your are using? It may be a compatibility problem.
    131,645 pointsBadges:
    report
  • BibekMajilla
    LPAD was the problem as this function was not available. Thank you all for replying. 
    90 pointsBadges:
    report
  • TheRealRaven
    LPAD is not a standard SQL function; it's an Oracle extension. (It might be in at least one other SQL dialect.) It won't be found in any standard SQL system unless you create the function.

    Is there a specific problem you'd like to solve with it? Alternative coding might be available.
    34,485 pointsBadges:
    report
  • BibekMajilla
    Yes. I have achieved the left padding with zeros using DIGITS  
    90 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: