• Accessing Remote Databases from iSeries

    I am learning about how I can access a remote data bases from a iSeries to another iSeries. I can not use DDM files using SQL statements. Please, can you explain me how I can access databases from a iSeries to other iSeries using embedded RPGSQL? Regards and thanks for your help.

    Jeshua5 pointsBadges:
  • How to keep whitespace in datagrid

    I have a simple .NET app. You key a SQL statement into a text box. It then connects to any one of 5 i-Series and returns a datagrid. I am curious as to how I can preserve the whitespace in the columns. These columns have some fields with data right and left justified. Other fields a large field...

    ToddN200011,050 pointsBadges:
  • Execute SQL statement using an RPG variable

    I'm trying to pass a cursor and data structure to a procedure. That procedure should populate the structure with the next row from a SQL cursor. Here's what I'm trying to do: ***************************************************** * * Fetch the next row from a cursor * * @param cursor - the name of...

    ITKE346,080 pointsBadges:
  • What is the best way to execute SQL statements in a CL program.

    What is the best way to execute SQL statements in a CL program? We can run SQL statements in a RPG program. I want to delete some records from a file using the SQL delete statement then organize it.

    SHhand25 pointsBadges:
  • Using NOLOCK in SQL Statement (SQL Server 2008)

    This is more a general question but a friend of mine is in the business of making websites and applications that aren't mission critical. So with that, is it bad practice to use the NOLOCK hint in SQL Statements? He was told by an SQL administrator that he should use it if he's satisfied with a...

    ITKE346,080 pointsBadges:
  • Error message CPF4326 appeared during OPEN for file EMPJ1 (C S D F). .

    Hi, I am getting the error below. What is this error...please explain it to me. Message ID . . . . . . : RNQ1216 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . : 08/18/13 Time sent . . . . . . : 14:11:56 Message . . . . : Error message CPF4326 appeared during...

    Jay1010 pointsBadges:
  • SQL query help – SQL Server

    Okay, I hope I can explain my dilemma... I need a SQL select statement that will Select part_number from RCTOOL the column part_number has values such as BR643-0034-344-34 AS54-54689 A77360-3454-34456-4 B7374-343-33-32-356-433-11-1 In each of these cases ALL we want it to return is the values UP to...

    MyDanes35 pointsBadges:
  • SQL Server 2005: SQL statement in a variable

    Can anybody help me? "HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE". FOR EXAMPLE : TO ASSIGN A STRING IN A VARIABLE, WE DO LIKE THIS: DECLARE @A AS VARCHAR(20) SET @A='HAI' PRINT @A OUTPUT: HAI SIMILARLY HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE.

    Narendar30 pointsBadges:
  • AS/400 – SQL

    I am reading a record in SQL with No Lock and its getting displayed in Screen. Based on the user input, I will/won't update the record. I want to check the record lock before performing the update statement. I don't want to check the SQL code after performing the update statement. What I want is: I...

    rajeshece1,215 pointsBadges:
  • SQL creating an unwanted duplicate of file

    The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than the library of...

    BigKat8,200 pointsBadges:
  • IF ELSE in SQL Server stored procedure

    I am using this code which is giving error: if (@report_type = 'CM') Begin Select distinct Region,sum(ClientCount) as ClientTotal Into #NewTemp From ( End else if (@report_type = 'AM' ) Begin ( Select distinct Region,Area,sum(ClientCount) as ClientTotal Into #NewTemp1 From End else if (@report_type...

    Rrj15 pointsBadges:
  • Problems using SQL CONNECT to a remote server within an RPGLE program

    Let me apologize in advance if I fumble with the terminology and don’t explain myself as clearly as everyone is probably accustomed to. The specific situation I’m dealing with involves the need to have an RPGLE program on the iSeries connect to a data base that resides on a remote server. My...

    mikechance81275 pointsBadges:
  • SQL Plus stops before finishing

    Why does SQL+ stop after running so many characters in a long SQL statement?

    rayfish201315 pointsBadges:
  • iSeries SQL Cobol

    In my COBOL SQL select statement that was previously running on V5R4, I was able to extract a date field defined with "date" as the data type. We are now on V7R1 and we get a data mapping error. No clue as to why? Any ideas? thanks

    Pgmr4660 pointsBadges:
  • Lost my SQL log

    SQL statements from a session (first session) have been lost because I opened a second SQL session and saved this when exiting AFTER exiting my first session. So, when I STRSQL, I only see the statements from my second session, those from the first session are gone. Can I somehow retrieve the...

    usuala20 pointsBadges:
  • Recursive SQL error

    For the life of me I can not see what my problem is. Any help would be appreciated. *************** Beginning of data **************************************** WITH RPL (LEVEL, PINBR, CINBR, QTYPR) AS (SELECT 1, ROOT.PINBR, ROOT.CINBR, ROOT.QTYPR FROM ITSTRU ROOT WHERE ROOT.PINBR = '8B714-0005651'...

    Timothy0125 pointsBadges:
  • Stored procedures

    What is meant by stored procedures? What is purpose of them and where can we use this stored procedure? Can any one provide the information regarding this? Thanks in advance.

    ravula700 pointsBadges:
  • DFU to SQL translator

    Is there a package that will allow the user to enter DFU commands and then translate to SQL and send that to the processor? The situation is that the logging program doesn't see DFU commands but does see SQL statements.

    DandyDon10 pointsBadges:
  • Using cursor in SQLRPGLE

    Can i use single cursor for multiple SQL statements? ex:  declare c1 cursor for select * from ....... also declare c1 cursor for select * from xxx

    varad40 pointsBadges:
  • I have a family tree and want to total all wealth for the entire family tree for any selected family member

    I have a database of a family tree of several separate families. Family of Joe smith, family of John Jones. etc. some families have only 1 member others have hundreds of children, grandchildren, great-grandchildren, etc. John Jones had no children so he is a family of 1 John smith had 2 children...

    3dJoe10 pointsBadges:

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