• SQL statements question

    I have an accounts ENTRY table with many fields like (ac_bal, ac_id , ac_date, ...etc) and I want to retrieve the summation of each account in each month as seen in the table below. 10-01 21-04 02-11-4 ..... jan Feb mar . . . Etc. Can anyone help?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL update from liba/myfile to libb/myfile

    How can I update a file with the same name (and fields) from one library to another? This is my SQL statement: UPDATE m3fdbqa5/oagrhe set uychid = 'TESTSQL', uysmcd = (SELECT uysmcd FROM mv4cdta001/oagrhe where mv4cdta001/uycono = m3fdbqa5/uycono and mv4cdta001/uyagno = m3fdbqa5/uyagno and...

    CLK50 pointsBadges:
  • Using Resource Manager in Oracle Fusion HCM Security

    Hello. I need to use Resource Manager (manager hierarchy) to secure a person security profile in Oracle Fusion HCM. Resources on this topic are scarce. Has anyone used Resource Manager to build a custom person security profile?  If so, did you have to use a custom SQL statement? Thanks!

    aviehmann5 pointsBadges:
  • Using SQL code to read a filename

    Can you write a SQL query that will read PDF filename from a dir and then match the filename to a data element in a table having the same name? For instance, the filename is 12345.pdf where 12345 is actually an invoice number. Can the query read the filename and then locate the same invoice number...

    Teedee5 pointsBadges:
  • What kind of testing am I doing?

    I am currently testing an oracle system. However I am not certain if I'm doing manual or technical testing. My daily responsibility is as follows: Application Testing according to business requirements The spec does not have details of the functionality of the system. However it consists of  two...

    Mvimvi5 pointsBadges:
  • PK allows null values in progress DB does this reduce performance of SQL statements?

    Hello, Primary Key allows null values in progress database, does this reduce performance of SQL statements?

    Blom5 pointsBadges:
  • SQLCBLLE not running correctly and does not produce MSGW

    I have been facing this problem lately: normally when there is a PGM ILE COBOL running on batch and triggers an exception it makes the batch job stop get go from RUN to MSGW, but when it is a SQLCBLLE and there is a problem executing an SQL statement it simply rolls back and continues execution...

    hamzahir60 pointsBadges:
  • How to select Oracle TOP 10 records

    We have a huge problem with our SQL statement in Oracle. We're trying to select the TOP 10 records that are ordered by STORAGE_DB (which aren't in a list from another SELECT statement). This code works fine for all records: SELECT DISTINCT APP_ID, NAME, STORAGE_GB, HISTORY_CREATED,...

    ITKE352,390 pointsBadges:
  • Can you force a user input in a SQL statement, then have the statement continue running

    Hi, can one in an SQL statement, when running in SQL, force a user input to be entered and when entered? The SQL continues to complete.

    Bugsy5 pointsBadges:
  • 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...

    ToddN200015,605 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...

    ITKE352,390 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...

    ITKE352,390 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,350 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:

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