STRQMQRY in batch on i5
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen Software/Hardware used: iSeries, SQL, CL
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen Software/Hardware used: iSeries, SQL, CL
35 pts.
I NEED SQL COMMAND TO EXTRACT THE NUMERIC VALUSE IN BETWEEN THE STRINGS
VCH:FR:AUD/120.18/51.26YQAC/1.35QKAD/14.47QRCO/14.47QREB/1.35QKSB/6.00WGSE/20.91UOVZ I NEED TO EXTRACT THE VALUES IN THE ABOVE STRING AND SUMM ALL THE VALUES USING SQL COMMAND EX:120.18+51.26+1.35.....IN THE ABOVE GIVEN REFRENCE Software/Hardware used: SOFTWARE
VCH:FR:AUD/120.18/51.26YQAC/1.35QKAD/14.47QRCO/14.47QREB/1.35QKSB/6.00WGSE/20.91UOVZ I NEED TO EXTRACT THE VALUES IN THE ABOVE STRING AND SUMM ALL THE VALUES USING SQL COMMAND EX:120.18+51.26+1.35.....IN THE ABOVE GIVEN REFRENCE Software/Hardware used: SOFTWARE
SQLRPGLE
I've Report to print using SQLRPGLE The Report criteria screen has around 15-20 select conditions...based on the conditions entered by the user, I build a query of type Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many select...
I've Report to print using SQLRPGLE The Report criteria screen has around 15-20 select conditions...based on the conditions entered by the user, I build a query of type Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many select...
Using SQL with MS Access and the AS400.
Each of the numbers in the column [New PART] is linked to the column [OLD PART]. The [New Part] column may have multiple rows of the same number in the same column but is it due to the association to the [OLISTd part] column, which are out dated numbers. Both the [OLISTd part] and the [new part]...
Each of the numbers in the column [New PART] is linked to the column [OLD PART]. The [New Part] column may have multiple rows of the same number in the same column but is it due to the association to the [OLISTd part] column, which are out dated numbers. Both the [OLISTd part] and the [new part]...
ms sql query problem with a case statement
[strong]This code works: SELECT passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...
[strong]This code works: SELECT passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...
Convert and Expand Field through SQL/400
I am using the AS400 platform and a novice with SQL. I have a common field in multiple files - some files define the field as numeric and some alpha. My question: Is there a way in SQL to first convert the numeric field to alpha and then expand the alpha field adding two leading zeros? If this is...
I am using the AS400 platform and a novice with SQL. I have a common field in multiple files - some files define the field as numeric and some alpha. My question: Is there a way in SQL to first convert the numeric field to alpha and then expand the alpha field adding two leading zeros? If this is...
SQL EXPLAIN
How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?
How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?
Updating a View
I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ
I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ
SQL Communication Area
Hello, Can anyone explain the fucntionality of the program QSYS/QSQROUTE in AS400. Thnaks in advance
Hello, Can anyone explain the fucntionality of the program QSYS/QSQROUTE in AS400. Thnaks in advance
SAP on SQL Server and NetApp
Hi Everyone, We are looking for some feedback from anyone who has used NetApp with SAP running on a SQL database. We are researching white papers, etc., but would really like to hear from some folks with hands on experience. What has your experience been like? Any performance hits? Any caveats or...
Hi Everyone, We are looking for some feedback from anyone who has used NetApp with SAP running on a SQL database. We are researching white papers, etc., but would really like to hear from some folks with hands on experience. What has your experience been like? Any performance hits? Any caveats or...
SQL 2008 Security: How do I give users access to just views within a DB?
[h1 class="subject"] [/h1] I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the best practice to...
[h1 class="subject"] [/h1] I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the best practice to...
Cal I load a record SET into a work file using SQL within RPGLE?
ALL - I have to process a set of Inventory Transactions based on W/H, Product, From Date, and To Date. Normally, I would jump into a Do Loop; read the SQL cursor; write the record to a work file; process until EOF. Can an SQL statement do all of that for me in one statement? I have not been able to...
ALL - I have to process a set of Inventory Transactions based on W/H, Product, From Date, and To Date. Normally, I would jump into a Do Loop; read the SQL cursor; write the record to a work file; process until EOF. Can an SQL statement do all of that for me in one statement? I have not been able to...
Best way to retrieve values, SQL or Queries and how?
Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like ( 60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record {4: ...
Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like ( 60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record {4: ...
Using AS400 SQL to replace a variable string
I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to...
I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to...
General ODBC Error - Why
I get an gernal ODBC error when running the below code. It looks like the sqlt is too long, but how can I get it to work as I need the query to be dynamic based on date. sqlt = "SELECT SCHED_TASK_EXEC.TASK_ID, SCHED_TASK_EXEC.TASK_TYPE, SCHED_TASK_EXEC.EXEC_TIME, SCHED_TASK_EXEC.END_TIME,...
I get an gernal ODBC error when running the below code. It looks like the sqlt is too long, but how can I get it to work as I need the query to be dynamic based on date. sqlt = "SELECT SCHED_TASK_EXEC.TASK_ID, SCHED_TASK_EXEC.TASK_TYPE, SCHED_TASK_EXEC.EXEC_TIME, SCHED_TASK_EXEC.END_TIME,...
SQL Query Issues with date math
Table with partial sample data would appear as follows: EQUIPNO ASSEMBLY START_TIME END_TIME 150 0 24-MAY-09 25-MAY-09 150 0 25-MAY-09 25-MAY-09 150 0 ...
Table with partial sample data would appear as follows: EQUIPNO ASSEMBLY START_TIME END_TIME 150 0 24-MAY-09 25-MAY-09 150 0 25-MAY-09 25-MAY-09 150 0 ...
Textbox input to a a sql dataset table in Vb.net
How do I input data from textboxes in Vb.net to ...a table in a data set ....and then display generated data back to some more textboxes ???? I am using sqlexpress ....Thx. mace100 Software/Hardware used: vb.net ,sql express
How do I input data from textboxes in Vb.net to ...a table in a data set ....and then display generated data back to some more textboxes ???? I am using sqlexpress ....Thx. mace100 Software/Hardware used: vb.net ,sql express
sql .net 2005 deployment
I am trying to connect my desktop application to sql server on a lan but the clients are being recognised as guest how do i enable ny appplication to run on the lan. I am using windows authentication. Software/Hardware used: vb.net, sql server 2005,P4 compters
I am trying to connect my desktop application to sql server on a lan but the clients are being recognised as guest how do i enable ny appplication to run on the lan. I am using windows authentication. Software/Hardware used: vb.net, sql server 2005,P4 compters
monthly labour accruals in ECC6
how are the monthly labour accruals calculated in ECC6 when then pay date in the beginning of the month ie 1 Ocotber 09
how are the monthly labour accruals calculated in ECC6 when then pay date in the beginning of the month ie 1 Ocotber 09
Forms in Access 2007
I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem? ...
I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem? ...
