SAP HRP 1000 & 1001
Hi For a recent Datawarehouse building activity, we’r to pull data from one of the SAP HR System to our SQL Database. I’m not much familiar with SAP and hardly have any idea about SAP internal architecture and I need ur help thus. I was told HRP 1000 Has all the object details and HRP [...]

Answer Question   |  June 7, 2012  10:07 AM
HRP1000, HRP1001, SAP, SQL

Transform rows to files in an SQL statement.
Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT  from table CLIENTES (sql against qsys2/syscolumns).   SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = ‘CLIENTES’ AND TABLE_SCHEMA = ‘MANEL’ Observe vertical orientation. Column 1 Column 2 xhrname Name xhrsurname   Last Name Now I would like to join this [...]

Answer Question   |  April 20, 2012  8:15 AM
AS/400, SQL, SQL statement

sql query
any one explain this query: select regexp_substr(char_name,’[^,]+’,1,level)as row_id from char_change connect by level<=(select length(replace(char_name,’,',null)) from char_change); this query is used to get the string value and print the row wise.

Answer Question   |  April 11, 2012  1:55 PM
SQL, SQL Query

Avoid Dulpicacy while entering Data in SQL db using VB6 as front end
Iam beginner in Vb & SQL. I am entering data like MemberName(txtMemberName.text) in sql database through VB6 front end form. I can enter same data in this field. Can any body help me in avoiding the duplicacy of the data. Following is my code on Save button :- Private Sub btnSave_Click() If (validate()) Then Adodc1.Recordset.Fields(“MembershipID”) [...]

Answer Question   |  April 11, 2012  3:00 PM
SQL, Visual Basic 6.0

Win a free Microsoft SQL Server 2012 Pocket Consultant book!
Interested in managing server groups and server activity?  Enter for your chance to win a brand new 2012 Microsoft SQL Server Pocket Consultant book Microsoft expert William R. Stanek.  To win, e-mail Michael@ITKnowledgeExchange.com explaining your security priorities for 2012. Good Luck!

Answer Question   |  March 6, 2012  3:24 PM
Security, SQL

Calcing quartiles using the median
I’m using this SQL to determine the median of a group of temperatures… select x.TEMP from QGPL/WEATHER1 x, QGPL/WEATHER1 y group by x.TEMP having sum(case when y.TEMP <= x.TEMP then 1 else 0 end)    >=(count(*)+1)/2 and sum(case when y.TEMP >= x.TEMP then 1 else 0 end)>= count(*)/2 + 1 If I want the 1st [...]

Answer Question   |  March 17, 2012  11:04 PM
IBM i, SQL

Win a free Microsoft SQL Server 2012 Pocket Consultant book
Enter for your chance to win a brand new 2012 Microsoft SQL Server Pocket Consultant book by William R. Stanek.  To win, answer below: What would you like to learn or improve about your SQL server skills over the next year?  Good Luck!

Answer Question   |  February 27, 2012  7:00 PM
SQL

Can I use SQL to delete a couple record from a member of a physical file?
I have a physical file that have multiple member and I delete a couple records from one of the member.  I’m not sure if I can use SQL to do it.  I’m using DFU to remove records now. Thanks!!

Answer Question   |  February 27, 2012  6:28 PM
AS400 DFU, AS400 iseries, SQL

Automated Query iSQL
I am very new to SQL and only have experience running my queries though iSQL Version 10 Build 3960 where I manually type (copy & paste) my queries. I would like to schedule a specific query to run at certain hours each day and then save the results to an excel or text file. Is [...]

Answer Question   |  February 28, 2012  12:33 AM
Automated SQL Query, isql, SQL

Access 2007 DB Project
Hello, I am setting up a database for a small airline. I have an ‘Aircraft_Table’ with the fields:

Answer Question   |  February 28, 2012  10:41 PM
Access 2007, Database, SQL

Exporting a (.csv) file from SQL 2005
Hi, I’m trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have [...]

Answer Question   |  February 28, 2012  5:57 PM
CSV, SQL

Execute SQL SELECT via RUNSQLSTM error
Trying to execute SQL-statement “SELECT * FROM mylib/myfile” give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

Answer Question   |  March 17, 2012  4:42 PM
RUNSQLSTM, SELECT statement, SQL

SQL How to split out the Time from a DateTime col then use that in a WHERE Clause
Hi, I have an SQL Server database that has a table containing 3 fields that I need to query. 1 field holds the date, and the other 2 hold the start and end times. What I was hoping to do was to split out the time only from the Start and End time fields and [...]

Answer Question   |  February 28, 2012  11:40 AM
SQL, SQL Server

SQLCODE 30 on fetch SQLRPGLE
Hello All,  I’m trying to execute a fetch into DS on a SQL statement and keep getting code 30: Number of host variables less than result values. The DS and SELECT statement both have the same number of values as far as I can see.  Here’s the DS and select fields code: D ClaimRecDS     [...]

Answer Question   |  March 17, 2012  9:09 PM
coalesce, NULL values, SQL, SQLRPGLE

Crystal Reports using SQL to create inner join
I am new to Crsytal Reports. I want to join 2 tables using a formula, which I am trying to do in SQL. I created a simple test report and I can get it to work if I don’t put any fields on the report from the joined table.  ie  -  if I just use fields [...]

Answer Question   |  March 6, 2012  9:47 PM
Crystal Report XI, JOIN, SQL

IT Data Updates and Auditors
I would like to hear how other shops deal with auditors regarding data updates made by IT staff.   We use DFU/FILMNT/SQL for occasional data fixes. We print and file a log with who and why the change was made. Then to appease the auditors, we journal pretty much everything. A report is generated twice a [...]

Answer Question   |  November 18, 2011  12:01 AM
AS/400, Auditors, DFU, FILMNT, iSeries, SQL

Problem converting numeric to date data type
I have a zoned decimal field as s 6 and i am trying to convert it to date format as mmddyy in sql…It giving error ..please help me out ..I tried using date and cast function but its not working !!

Answer Question   |  March 19, 2012  11:24 PM
DB2/400, SQL

InfoPath cannot connect to data source
Hi all, I have an InfoPath form in SharePoint 2007 that has dataconnections to SQL server DBs. I have a group of users that have been using them for the past few months with no problem. The permissions on the site have not changed but users can no longer access the Data connections. They get [...]

Answer Question   |  November 14, 2011  7:46 PM
Data Connector, Infopath, SharePoint 2007, SharePoint permissions, SQL

how to store radio button responses in MySQL
I am creating an online test. Each item has 5 response options (radio buttons with 1-5 values, or 5-1 values depending on the question). How do I store these values in a database, to be able to score the test later?

Answer Question   |  November 8, 2011  1:53 PM
HTML, Radio buttons, SQL, Testing, Web development

Select substring from clob-field with sql
How do you copy substring from clob-field with SQL if substring from/to positions are varables? This works OK (RPG free w embedded sql): exec sql select substr(myclobfield, 25, 70)                 INTO :mystring                 FROM MYLIB/MYFILE; [/pre] Whereas this causes a compilation error: from = 25; to    = 70; exec sql select substr(myclobfield, :from, :to)                 [...]

Answer Question   |  March 31, 2012  3:03 PM
Embedded SQL, RPG, SQL, SUBSTR, Variable Length Subnet Mask