• Trap SQLCODE from RUNSQLSTM

    I have a RUNSQLSTM that updates a table. When it hits a duplicate, it quits and returns SQL9010. What I want it to do is just skip the step that got a duplicate and move on. Is there a way to do this?

    khalon15 pointsBadges:
  • Compiler

    Which compiler should I use in SQL?

    kitukisu5 pointsBadges:
  • Expression to insert value to a table column in SQL

    My CL program has RUNSQLSTM. The SQL source has some SQL statements(source is of type SQL) which inserts value to a file. I need to change the SQL to have a column(FLD1) value like this (A*B*C)/10**D. A,B,C, and D are file fields. The attributes are like this A- (15,2) B- 13 C - (13,5) D - 1 I have...

    RamvishakRamesh2,505 pointsBadges:
  • Entry Level Vendor Neutral SQL Certification

    Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks...

    MG357805 pointsBadges:
  • AS400 to Oracle query

    Can I query a Oracle database directly from AS400 using interactive SQL.Will I need to install any driver or is there a way around?

    Atti123135 pointsBadges:
  • DFU to SQL translator

    Is there a package that will allow the user to enter DFU commands and then translate to SQL and send that to the processor? The situation is that the logging program doesn't see DFU commands but does see SQL statements.

    DandyDon10 pointsBadges:
  • PLEASE HELP SQL CODE

    need some help, my code is below as follows with my questions indicated by *. SET ECHO OFF; SET FEEDBACK OFF; SET TERMOUT OFF; SET HEADING OFF; SET PAGESIZE 400; SET LINESIZE 600; SET NEWPAGE 0; SET TRUNCATE ON; ***at this time i am truncating the whole document how can i just truncate a specific...

    Alex88090 pointsBadges:
  • Debug

    How to debug an SQL Stored Procedure?

    bigT35 pointsBadges:
  • sqlcmd :0 rows updated

    When I run exec dbo.subprogram from sql server management studio, it executes and returns result as many rows affected: But when I run from cmd C:\Users\mssadmin>sqlcmd -S servername -d databasename-q "EXIT( exec dbo.subprogram)" it retunrs as 0 rows affected. What could be the problem

    Beena5 pointsBadges:
  • SQL SERVER

    The SQL Server mobile edition is supported on?

    siphesihle10 pointsBadges:
  • Complex sort for SQL Query?

    I have a table: MY_TABLE IDENTIFIER (VARCHAR) NAME (VARCHAR2) DATE (DATE) SELECT NAME, IDENTIFIER, DATE FROM MY_TABLE ORDER BY IDENTIFIER, DATE; So that works great for ordering the identifiers (basically making them look like a grouping in the output). Then sorting them by date (makes it sort...

    KGNickl50 pointsBadges:
  • Database

    How to create a database of prison management system using SQL?

    abuhafsah25 pointsBadges:
  • Oracle first or SQL

    Hello Everybody, I would like to learn Oracle. The question is: should I learn SQL before I start to learn Oracle? Why? Thankx Zaid

    Zaid198140 pointsBadges:
  • using SQL in RPG

    I want to use the following 2 SQL statements in 1 RPG program and have the results print out. How can i accomplish this task? Not sure how to do even 1 SQL statement and have it print, let alone 2. Select RNSREGN region, COUNT(RNSINVN) #Orders, SUM(RNSQTY) #Books, SUM(RNSTOT$) $$ from...

    rmb115 pointsBadges:
  • Link to file in IFS – file not found error.

    To avoid sending very large SQL results through the email system I have created a command to place the file in the IFS and just send a link to the user via email. When I click on the link to open the file, it opens right up. When the users click the link, they get a "file not found" message. Why? I...

    Jsuper25 pointsBadges:
  • Best Technology for learn

    i m the computer graduate doing job in technical support & wants to learn new technology can u suggest any new technology

    santosh1234567891030 pointsBadges:
  • need help with measuring dates

    I am trying to select records from a table where the CREATEDT field is between SYSDATE and 20 days prior. select distinct(createdt) from U_table where to_char(createdt, 'dd/mm/yyyy') between to_char(sysdate, 'dd/mm/yyyy') and to_char(sysdate - 20, 'dd/mm/yyyy') There are records in that table that...

    jkeri360 pointsBadges:
  • Group By con ORDER By en V7R1

    Hola, antiguamente en la V5R4, cuando escribiamos una sentencia SQl que utilizaba GROUP BY, el sistema solo ordenaba por los campos definidos dentro del GROUP BY, ahora , en la V7R1, no lo hace, y me obliga que escriba el ORDER BY y a continuacion los campos de Ordenamiento, cabe aclarar que el...

    2602196240 pointsBadges:
  • Sql Search

    Hi, I have a Search box on my site at top. Where visitor can enter any keyword. I have Full Text Search enabled on my DB and index the Columns. I have one Columns SalesTitle in one of Table Catalog.Product, which contains almost our required keyword, like ProductNumber, Description, BrandName,...

    Mr. SEA130 pointsBadges:
  • how to store the radio buttons checked value in a database (sql)using vb.net

    Iam having 2 radiobuttons in my web form rbown and rbrent for the user to selcet whether he owns a house or he rents.I assigned own and rent as text propertis to the 2 radiobuttons and groupname as group1. Iam trying to store the text values depending on the selection of the radiobuttons in the...

    Anupamak1515 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