• Data Fields outside of report section

    I am looking at a previously written Crystal 8.5 report in which most of the data fields are outside of the report section. I can only see these fields if I reduce the report size to 50%. I have tried landscape orientation and adjusting the paper size to 11X17, but I still have many fields that I...

    Mystic15 pointsBadges:
  • t-sql and AS400

    I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria.  The words that I need to sort-by would be...

    CompEng1,185 pointsBadges:
  • What is the best why to get started in DBA

    I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self sufficient as...

    CompEng1,185 pointsBadges:
  • SQL to query a file

    I want to use SQL to query a file and summurize data, using multiple scalars( min, max, sum) and display the results on a workstation screen.  Can i use one select statement in RPG iseries or should I create a stored procedure?   Any code samples,etc would be greatly appreciated.  

    rmb115 pointsBadges:
  • Finding Holes in Numerical Sequence

    I need help in identifying the missing numbers in a large query. The only problem is that some of the numbers may be alpha and numerical combined or not-they are mixed. Yet all the numbers are in the same column.  The query looks like this...

    CompEng1,185 pointsBadges:
  • Is there a way to find out when a patch was last applied to an instance?

    Is there a way to find out the date a SQL Server instance was last patched?  I need to keep track of dates each of my instances had a patch applied whether it be a security patch, hotfix or service pack.  I looked in the ServerProperty function but did not see anything that would return this...

    Mrhr246120 pointsBadges:
  • How can do iSQl*Plus login for DBA

    I want to create iSQL*Plus login for DBA. How can i do this ?

    MelanieYarbrough6,345 pointsBadges:
  • Return only one word– SQL

    Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. For example, if an entry in...

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

    DanTheDane2,555 pointsBadges:
  • VERY slow server startup and shutdown

    Hi everybody! We have a problem on our Exchange 2003 server thats been getting worse and worse. We have a Dell PowerEdge 2850 server, and every time we try to shutdown or restart it, it take 10 to 20 minutes just to shut down and another 20 to startup. Sometimes we have to force shut it down...

    Shestopalov55 pointsBadges:
  • MS SQL query to update a table with the last entry in another table.

    Hi, Could anyone please assist. I'm trying to update a Reporting Table with the last entry in another table. I've tried to arrange the table according to the ID row. This works great. Then the query to get the last entry woks as well, but to get the two to work together and update the table is a...

    GPNel200675 pointsBadges:
  • 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 !!

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

    Dcantwell470 pointsBadges:
  • 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?

    DanTheDane2,555 pointsBadges:
  • 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...

    tegarvey35 pointsBadges:
  • Question on Database Development Options

    Our organization is going to build a database program where there will be millions of entries. Data entry will be done from around the country. The central server will be located in the capital city. Presently we use Windows OS, planning to migrate to Linux OS in next 4-5 years. I'd like to know...

    Abdurrahman40815 pointsBadges:
  • 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 from "sal-rep" the report works.  As soon as...

    Sparis5 pointsBadges:
  • 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!

    Michael Tidmarsh30,585 pointsBadges:
  • REGULAR EXPRESSIONS / META CHARACTERS REGEXP_INSTR

    I'm a bit confused here. Looking at the Student Guide from the Intro to Oracle 10g SQL class, on page 8-6 (volume II) it states that the ^ represents "Beginning of Line Anchor" then four pages further on 8-10 it states that the ^ inidcates NOT. Can anyone explain? This is the first time I'm seeing...

    Midolci0 pointsBadges:
  • 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 then use these times in the WHERE clause...

    Darraca290 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