1
  • Dynamic ALIAS creation in iSeries

    I need to make a query against a physical file that has 30 members. For this I have chosen to create ALIAS, this means that i have to create 30 aliases. Is there any way to iterate alias creation through a FOR statement dynamically?

    GianDamico25 pointsBadges:
  • Locating active procedures in iSeries SQL

    I have a strange problem in iSeries SQL. I'm running a script that fails every time it tries to create a procedure that already exists. The script is quite involved and necessary to complete a number of projects. Is there a way I can determine if specific procedures within the system already exist...

    ITKE346,430 pointsBadges:
  • Character in Cast argument not valid

    I need to retrieve the RRN and use it within my RPGLE program. I have the Select RRN(file) statement, but I get a Character in Cast argument not valid when executing. Any suggestions?

    trishahles10 pointsBadges:
  • iSeries SQL function in a SQL procedure

    Hi everyone. I have created an SQL procedure using Create Procedure interactively after starting SQL with STRSQL on an iSeries V5R4. I then created a function using the Create Function statement interactively in SQL on the iSeries. I put the function in the select field prior to the where clause....

    Seeker115 pointsBadges:
  • Compare part of string to field

    Hi.  Hopefully a simple one but beyond my self-taught abilities in iSeries SQL.  I have a file with one field containing customer order details including their purchase order reference such as 'A1-123'.  The first part of the PO reference is a branch identifier.  Unfortunately, as it is a free...

    Keithbrc35 pointsBadges:
  • Change Initial Program

    how do you change the initial program and library for all user profiles preferrably using SQL.

    Rhinopop15 pointsBadges:
  • iSeries SQL case on AS/400

    Is there an equivalent to case when exists on the as/400?

    Alanlev5 pointsBadges:
  • iSeries SQL ISNULL Equivalent

    What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?

    Jaggerdude60 pointsBadges:
  • Deleting unmatched records from a file in iseries SQL

    I'm trying to delete unmatched records from file A based on file B. The files are matched by ListNo. Code: DELETE FROM DVMURRAY/INSRP100                                   WHERE SHListNo = ALL                                     ...

    PSMurray530 pointsBadges:
  • What does this mean when SQLCOD = -206? I need to write 2 sets embedded SQL statement in my program.

    what does this mean when SQLCOD = -206. I need to write 2 sets embedded SQL statement in my program. first one is one and I was able to fetch data but the 2nd one has error just right after I declare cursor. Here are the statements EVAL SQLSTMT2 = SELECT_H_2 + WHERE_H_2; + AND_H_A; EXEC SQL PREPARE...

    Huana5 pointsBadges:
  • Set DataTable name in returned data set

    I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset.  The stored procedure is being called from C#/.NET code.  The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,...  when the dataset is...

    LordPerrin15 pointsBadges:
  • Plus signs in fields when using a date from a file compared to the month and year function

    I have included the complete SQL statement. I keep getting +++ in ontime and percent. select c.totallines, c.ontime, decimal(((c.ontime/c.totallines)*100),15,2) as percent from (select decimal(sum(b.totallines),15,2) as totallines, decimal(sum(b.ontime),15,2) as ontime from (select a.ord as ord,...

    LoriWood20 pointsBadges:
  • Retreiving AS/400 SQL scripts

    When I start sql on our iSeries, the system returns my previous scripts I have run. Which fle do these live in in the iSeries and can I report on them?

    Morticia00110 pointsBadges:
  • Need to know the date and time a particular sql command was fired through an interactive session

    Is it possible to find the date and time a particular sql command was entered. Iam able to view the commands entered in an sql session but not able to find the date and time the commands where fired.

    JohnsonMumbai1,160 pointsBadges:
  • AS/400 SQL

    want to all some users to run an SQL for display only and not allow update of delete. is there a way to do this

    Cficik10 pointsBadges:
  • Iseries SQL Auditing

    I want to audit interactive SQL statements. Is this something I can do and if so how ?

    Brooksiec5 pointsBadges:
  • COPY data between to files with SQL in iSeries

    hi, i need help with this: i have two files in Iseries one of them is new and other have old records and i pretend with sql copy some records. But file 1(new) and file 2(old) they don't have same collums file1 file2 fielda fielda fieldb fieldb fieldc filedd fieldd how can i make the correspond...

    BUG68235 pointsBadges:
  • Need an iSeries SQL that will reduce mutilple entries to one per type

    I need to produce an extract that is a combination of two files. File A has a policy number and a folder type. File B has the document number. File C will be the product of File A and File B. I can join the files on the policy number and folder type to get the document number, however, I need to...

    FCARPENTER200 pointsBadges:
1

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