AS400 – SQL

1215 pts.
Tags:
AS/400 SQL
AS400 - SQL Queries
SQL queries
SQL Query
I want to use Functions in Update Queries Set operation

Update File Set FName = Substring(Name,1,10)

Where EmpNo = 99

How to perform this one using SQL Queries

 

 

Answer Wiki

Thanks. We'll let you know when a new response is added.
Below is the sample code for what you are asking,hope it will help:
Declare
name varchar(10);
begin
name:=’Juzer’;
Update File Set Fname = Substr(name,1,3)
       Where empno=99;
end;
/

Discuss This Question: 2  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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    If FName is CHAR (10), then try this:
    Update File Set FName = Substr(Name,1,10)
           Where EmpNo = 99
    Are you seeing an error message? Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    Below is the sample code...   For the attempted 'answer', can you explain how that code would be executed? Note that the question title is "AS400 - SQL".   Tom
    125,585 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following