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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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