• SQL transcation log file

    Hi there, I developer is building a commercial application for me.  We are stuck at some point that we seem unable to deal with. The application being built is capable of dealing only with tables with primary keys.  We need it also to handle tables with no primary keys.  For clarity, we have no...

    Yba5 pointsBadges:
  • Simply, How do I populate Fields from a SQL Statement in Oracle Apex?

    This is not a facitious question.  I am new to APEX.  I have looked over this stuff for weeks, but I can't find a way to run an SQL statement and populate text boxes. I have tried the famous "For C1 in (Select..." but, when I put it into any of the areas, the event never sets off.  I've tried...

    Ddape20 pointsBadges:
  • as400 sql – non numeric data in numeric field

    is there a function I can use to avoid and abend when sql hits a numeric field that contains non-numeric data. sql: select * from LPDtst/ARCOMB WHERE ACAOF# <0 Error: Selection error involving field ACAOF#.

    oldpgmr75 pointsBadges:
  • On the as/400 i series can one use SQL querys to update file

    Cobol uses some kind od IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be...

    nitzinger385 pointsBadges:
  • Retrieve data from Oracle9i to SQL server

    Currently my database client using SQL Server 2005 and there have another database whereby is using Oracle 9i, I wanted to retrieve the data from the oracle whereby query in SQL server 2005. 

    Xue8715 pointsBadges:
  • SQL to insert comma-delimited string value to table column

    I have string like '1,2,3,45,6,7,8' I want to insert each comma separated value in a table column...my output look like this: COLUMN 1 2 3 45 6 7 8

    231219835 pointsBadges:
  • View t-sql SPID is executing

    Is there a table that I can query to view what sql statements a spid is running? I do not want to use the dbcc inputbuffer.

    Rick Martinez585 pointsBadges:
  • SQL saving off data created to copy into new database

    Data is created in one SQL DB for testing and then a new DB is created. Is there a way to save the data you need for testing in the new DB, so you don't have to create it each and everytime for testing?? Any suggestions would bew appreciated.  Thanks...

    Flyershockey25 pointsBadges:
  • Optimizing/Indexing to find last transaction

    I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...

    MODMOD0 pointsBadges:
  • sql what is TOSTMF

    In SQL what is TOSTMF for an output file, and how do I use it?

    GlendaBennett15 pointsBadges:
  • Running a job in SQL 2005 by calling a batch file from a As400 CL program

    Hi, I already asked this question before but did not get any reply. Anybody please help.. I am calling a job on AS400 which uses RUNRMTCMD to execute a batch file on sqlserver 2005 server. This batch file uses sqlcmd command to run a job on sqlserver. When I execute this batch file manually from...

    Gullu15 pointsBadges:
  • Pros & cons to have a typical star schema but with only one fact value field and a thousand attribute names in one of the dimension tables?

    Want to build a kind of a scientific fact search and analytical engine for a lot of different types of measurements hosted in a lot of source tables and columns. A star join schema is built and data is copied (ETL) from the sources as usual - but all source column values are stored into a single...

    Rwg30 pointsBadges:
  • Accessing an Access DB from Outlook via VBA

    Hi The situation: In Outlook I get a message from a server. The content of the message needs to be put into an Access db. But, there may not exist another message with the same date. So, I need to look into a db if there is already a message with the same date and time. If there exists one, then it...

    Camastanta50 pointsBadges:
  • Physical file over 600 000 000 records

    Hi We have a Physical file which has more than 60 million records in it. In our application we search for the particular records based on 6 fields as a search criteria (web based) , search process are done in SQL Procedures. Even when i creatd a LF based on the mandatory search fields , we get  a...

    As400programm10 pointsBadges:
  • SQL/400 field editing

    What is the best (easiest!!) way to add editing to fields in an SQL-created table?

    DanTheDane2,555 pointsBadges:
  • SQL question

    One table named as employee has 3 columns (name, salary, department). I need to retrieve the employees whose salary is greater than average salary of their department. that is name    salary   department iioo      10000    Technical aaaa    15000     HR pppp    17000    ...

    Hema19865 pointsBadges:
  • embedded sql update

    I have a prog that should update all KY cust master records with the new code AR. I run the program but nothing happens. The file remains unchanged. I am new to embedded sql so what am I doing wrong ?? D OLDWH           S              2    INZ('KY')    D...

    ToddN20006,360 pointsBadges:
  • Stored Procedures on AS/400

    Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks...

    Ashnirody100 pointsBadges:
  • How to use the SQL update statement with a join to another file to get the correct selection

    select count(op140m.pfpn) from prdat/op140m join cgoderi/op140mup ON op140m.PFCORP = op140mup.PFCORP and op140m.PFSTCN = op140mup.PFSTCN and op140m.PFPN = op140mup.PFPN and op140m.PFSTCN = p140mup.PFSTCN and op140m.PFEFDT = op140mup.PFEFDT I have 1 table op140mup with 8088 records and op140m with...

    Chrisjegoderie30 pointsBadges:
  • Performance Problem

    We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index...

    Ashnirody100 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