• SQL and RPG 400 (SQLRPG) Variable lengths help required.

    Please could someone help me with the following, I am new to SQL and have been tasked with the following:- I am writing an RPG program where the user will be able to do a search by entering up to 15 characters to find part numbers. I know how to do this using SQL but I am struggling with this when...

    AS400Kate15 pointsBadges:
  • How to keep date format when creating Index on a Table

    I have used CREATE TABLE to create a PF which contain a DATE field. And then use CREATE INDEX to create a LF with data selections. However, when I check the DATE field, I find that, in the PF, its Date Format is *ISO; but in the LF, its Date Format has been changed to *DMY. How could I keep the...

    MacroJ20 pointsBadges:
  • I’m interested in creating a web form that will deposit information into a SQL Server database.

    I'm interested in creating a web form that will deposit information into a SQL Server database. What's the best way to do this and what software exists to accomplish this? I have experience creating Access forms that connect to a SQL Server back end.

    Eabouzeid175 pointsBadges:
  • Find the SQL value behind the decimal

    I need to know if the numbers after a decimal point are greater than 0. What is the easiest SQL syntax to do this?

    Tslake9925 pointsBadges:
  • Event ID: 2803 and 17137 Question

    I have recently installed SQL 2005 Express and Symantec Backup Exec for Windows 2003 SBS. I have not created any backup jobs and do not have an Active SQL DB just yet. However the following Information Events are being logged under Application Event every 5 minutes. Is this normal and is it...

    PCJunkie870 pointsBadges:
  • SQL Writer error message – SQLDUMPER library failed

    error sql writer - sql dumper liabrary failed initialization install corrupt or tamper with

    Mmichals15 pointsBadges:
  • Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 pointsBadges:
  • Windows Scheduling iSeries Data Transfer

    I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe...

    Heather4000 pointsBadges:
  • VB updates to DB2 table.

    Why does as DB2 table need journaling when doing updats from VB SQL? Our setup is SQL, link server, local DSN to AS400.

    SittingBull25 pointsBadges:
  • Compare Two Tables With Identical Fields

    Need to compare two tables A & B with identical fields and report when rows don't match and rows from B are missing in A.

    Jaggerdude60 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT

    I tried example 6 from the book SQL for Microsoft Access and got the error message" CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong? Thanks, INSERT INTO Toys...

    Fredking5 pointsBadges:
  • SQL indexes

    hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Automate TSQL Query Output

    I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?

    Eabouzeid175 pointsBadges:
  • Count Distribution

    From an input table consisting of YEAR and COUNT, e.g. YEAR COUNT 1999 3 2000 4 2000 7 2000 15 Can a Pivot Table or SQL Query be constructed to output a Yearly Count Distribution? e.g. YEAR 1->9 10->19 20->29 1999   1 2000   2        1 Thanks, JaG

    Jaggerdude60 pointsBadges:
  • Sql Server CAL

    I have a Sql Server Enterprise 2005 64X, installed licesed by processor, I what to cut budget so thougt if I change to CAL licensing could save money, but know how to calculate how many users are currently conecting to my server. How can I get this info?

    Noyo775 pointsBadges:
  • SQL Syntax Error SQL0104

    I have to recreate a duplicate logical file, but I can't use the crtdupobj command because it doesn't recreate the correct library pointers. Using the dspfd command. I'm attempting to recreate the logical file in a different environment(library). Using the exact same commands (different library)...

    DLM2007285 pointsBadges:
  • retrive data from 3 tables

    HI i need to retrieve data of 3 tables using one more master table wat are the possible options Union,Joins anything else? with good performance please guide for considering the performance as the retrival count is huge in my case

    Inprise610 pointsBadges:
  • Script to add a Period after a Middle Inital- Then query AD for User ID

    I would like to create a script that parses an excel spreadsheet column with user's full names (I.E. 'John A Smith') and inserts a period (.) after the middle inital character. (I.E. 'John A. Smith') Once the middle inital period has been inserted, I would like the script to query Active Directory...

    AASuperTech5 pointsBadges:
  • MySQL brain teaser

    This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “...

    Michael Morisy8,323 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