Retrieve SQL messages from Joblog

Hi, I'm on 6.1 and I have RUNSQL in a CL program. The statement is 'UPDATE ...' and run's okay but I need to get the SQL MSG SQL7957 with the number of rows updated or the SQL0100 (row not found). I can get this with RCVMSG but only in debug mode. Can anyone help me? Rui

RuiFerr15 pointsBadges:

How do we work with SQL?

How do we work with SQL and what does it help in DBMS?

veronicahmungai20 pointsBadges:

Test environment – stop iSeries journaling – how to get past hard errors?

We have stopped journaling on our test system (library driven). How can we get around the CPF4328 error - "Member (FILE) not journaled to journal *N'?

ItsHerAgain30 pointsBadges:

Pagination in DB2 Z/OS

I have a select query that returns 500000 rows. I need to display 100 rows per page. When the user navigates to next page, I need to display the rows between 100 and 200 and so on. I am using DB2 v10 and java. My query is taking long time to fetch the data even though I am fetching 100 rows at a...

Vithal25 pointsBadges:

Configure on availability group for DBs

Can I configure on Availability Group for few DBs, and then mirror with synchronous automatic failover in same SQL instance? Would that be possible?

VaidyaSQL5 pointsBadges:

SQL0666 SQL query exceeds specified time limit or storage limit

I have a web service using a iDB2 connection to return a Data Set. I am searching a large table on a partial string to find a portion of a serial number, I kept getting this SQL0666 error so I had a new LF created over the file on the i-Series side by the text field I am searching on and it now...

ToddN2000100,095 pointsBadges:

Is there any tool to validate the App consistency?

Using the load generator I created, a random writes to SQL. With VSS and without VSS, I tried to create a backup. In both scenarios, I can able to make the SQL up and running without any issues. How do I produce the inconsistency in the backup, practical scenario when the Flush thaw will be useful...

asvignesh5 pointsBadges:

Active Directory clients cannot use some software

Hi Experts, We have an Domain controller (Windows 2008 R2)  installed with all AD group policy implemented. We are facing an weird issue that as we install SQL or Visual Studio 2012 or later one, these all software require option "Run As Administrator" to run all options incorporated in them. Now...

MandeepSahani5 pointsBadges:

SQL insert error

Hi, I am setting a process of creating a table and inserting data into it from another table. I created a table "example". When I run the SQL command insert into mylib/example select (some specific columns) from example2 where User = 'sqakxb'. It is throwing exception error. When I run the command...

Kaustav0000165 pointsBadges:

Microsoft Access. Passing an ID/value to a subform. or between forms

Hello Everyone. I am using MS Access 2000 I have a form (frm_cboclient)that has a combobox on it that I populate by querying a client table for clientID and client name. What I would like to do then is have a subform that will display all my order infomration from my order table, where the clientID...

Gryphon0 pointsBadges:

Query/400 to give Column totals

Hello, I would like to use Query/400 to provide a particular column total. I have about 6 fields and the final field is Inventory Cost that needs to be totaled in the end in the database file. I know it is easier over SQL, but I would like to know if this is possible.

yaazhisai260 pointsBadges:

joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

what is the diffrences between oracle proprietary join and sql 1999 compliant joins

Muktioracle50 pointsBadges:

SQL/400: Call CL program

From stored procedure in SQL/400, I want to call the CL program. I have created the wrapper program for calling CL as SQL procedure.(qcmd). How can I pass the param with quotes to CL program? SBMJOB CMD(CALL PGM(abc) PARM('parm1' +'parm2 'prtn1')) JOB(prt1) + USER(braha1)

Bhusha40 pointsBadges:

[SQL0029] INTO clause missing from embedded statement.

HI, I have written lots of RPG/ILE & CL & COBOL programs in iSeries. I never worked on procedures & UDF. Now I'm learning these. I'm trying to create a procedure. This is the code. It's compiled without any errors. While running I got the below error. CREATE FUNCTION SUS.REWT(p_value...

HABBIE895 pointsBadges:

Is there a problem with my file server and SQL or the operating system?

Hello good day, I have a LAN with star topology-tree. (Internet dedicated, 1 router, 2 servers, 1 switch, 1 AP, 40 PCs) OS Windows Server SBS 2003 and PCs with Windows 7 and 8. The network cards in the servers are 1GB, Router 1GB, 1GB switch PCs 100MB. Cat5e cabling. But the data transfer is very,...

JASAvtek5 pointsBadges:

SQL Select columns with columnized ntext data

I have a table with 20 columns, where column 2 is an ntext, and it contains 133 comma separated 'fields'. How do I read the 19 columns and include in the output, the 133 columns from the ntext column.

PeterGrierson45 pointsBadges:

Using Decode in oracle sql query for Debtors Analysis Report

i have a table called transactions in my oracle database which stores data for employees under particular employers. each member has an account and employer_id with transactions , the table has fields as below. TRAN_ID, TRANTYPE_ID, PENSION_ACCOUNT, EMPLOYER_ID, TRANAMT, SALARY, TAXEDAMOUNT,...

wiri5 pointsBadges:

SQL0204 error for LPAD

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?

BibekMajilla90 pointsBadges:

IF…THEN for a SQL SELECT statement

How do I do an IF...THEN for a SQL SELECT statement? So I have this already: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product How can I do it?

ITKE1,067,975 pointsBadges:

SQL Convert Legacy Integer Date to actual date for Comparison issue

I have a PF with a date broken in to three fields: 4 digit year, month, and day. I'm converting it in my SQL statement as follows: DATE(year||'-'||month||'-'||day) This works great for valid dates! The problem is there are invalid dates in the file such as 2/29(non leap year),30,31 or 4/31. There's...

Dcantwell480 pointsBadges: