• Using combo box to populate a sub form which is used to create a new record

    Using Access 2003 I have a table called POTable which contains 4 fields. PONOID (primary Key and AutoNumber), PONO (text), VENDOR (text), GENDESCRIP (text). I have another table called MRRTable. This table contains several fields with one of them being PONOID (number). What I want to do is the...

    Gbullo70 pointsBadges:
  • sql update command to update a date-of-birth

    I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR

    Mji50 pointsBadges:
  • sql update command to change text

    I need to modify all characters within a text field. Some of the fields will contain 2-5 characters, others will contain 20-200 or more. The field is defined as Text 4000. I want to replace every letter with "K" We have a Select statement: select...

    Mji50 pointsBadges:
  • RPG Programming Standards

    I'M LOOKING FOR RPG PROGRAMMING STANDARDS. We have always had standards example if you create a report the report should have the date, title, program name, page numbers.  Does anyone have a stanards document or is there anything on the web?   I appreciate your help!    

    Superbusy15 pointsBadges:
  • Territory code in UDB DB2 database

    A reader wrote in with this question: <i>Can you explain the meaning of the territory code when creating a db2 udb database? Certain documentation say that the territory code determines the way dates are displayed but I've experimented by creating several databases with different territory...

    Leah Rosin575 pointsBadges:
  • Count/Sum Question

    Hi I have a field with only 2 values. 0 and -1. I am interested in counting the -1's that occur only if they occur 4 or more times consecutively. Therefore, if the output were 0, 0, -1, -1, 0 the output would be 0. However, if it were 0,0,-1,-1,-1,-1,-1, 0, 0, -1,-1,-1,-1 the sum would be 9. Help...

    Chhmusic15 pointsBadges:
  • Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?

    I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? I'm assuming there...

    Srichfdic20 pointsBadges:
  • SQL query error: token DATA

    I am new to Db2 on iSeries. I am running some SQL script files using JDBC to create a repository on DB2 for my project. The query is of the form: Create table tbl_name(col1 datatype(size),...... ,coln datatype(size)) DATA CAPTURE NONE; I am getting error on token DATA.. I tried to execute this...

    AS400 - Ask the Expert485 pointsBadges:
  • Enabling php_oci8 on win server 2003, IIS 6, fastcgi

    System setup: Windows 2003; IIS 6 with fastcgi enabled; nts PHP version 5.2.10 (and 5.2.11 just tested); Oracle 9i (full client) Problem: When I add in the extension=php_oci8.dll into my php.ini file, I get a startup error "Unable to load dynamic library 'C:phpextphp_oci8.dll' - The specified...

    Darryn765 pointsBadges:
  • Contest Update: Nominate a member and you could win 1 of 5 Amazon gift cards

    A quick and important update on our Panasonic flatscreen contest and the nominations process -- we will be giving away five (5) $20 Amazon.com gift cards at random to members who nominate someone in the community feedback form here. Thanks!

    ITKE366,235 pointsBadges:
  • coding in c#.net for developing a window

    I need a tab in tools->options window.if we click on that tab it should give 2 text fields one with some default file extensions seperated by semicolon and another text field with valid extensions seperated by semicolon which should be editable i.e user can add/delete an extension to it.for that...

    Devisri20 pointsBadges:
  • AS/400 ASP%

    what is the default ASP% in AS/400 and what is the procedure to define our own.

    now225 pointsBadges:
  • The most-watched IT questions this week: Sept. 22, 2009

    Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

    Michael Morisy8,323 pointsBadges:
  • DB2 Select on a large number of rows/

    I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the records I want to select for...

    Michaelf215 pointsBadges:
  • Extracting data from a DB2 table using IKJEFT01

    I'm trying to extract data from a DB2 table via an SQL query and use IKJEFT01 to create a flat file. However, one of the non-key fields contains characters that are not nulls but non-printable. Whenever IKJEFT01 extracts these characters it changes them to nulls in the flat file. Is there an...

    AlanJ5 pointsBadges:
  • Defining a sort variable (ORDER by) in RPG SQL

    I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG SQL?...

    MurrayInfoSys940 pointsBadges:
  • Display or enable/disable radio button based on response from another radio button

    Hi, I am working on this project where I am dynamically creating a radio button based on the database values. I am using HTML, ASP and COM Components. The portion where I grab the data from the database is working fine. <% For i = 1 to varDriverCount %> <input type="radio" name="Design"...

    Jinisha0 pointsBadges:
  • SQL join two counts on same table

    I have two different SQL statements that each is a count on the same table, but a count of different columns. I'm trying to combine them into a single statement, but am having trouble doing so.  The two statements are:  SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM `rankRaw`...

    Shantheman15 pointsBadges:
  • MarkAndBackupLog step in BizTalk SQL Agent backup job is failing – says db_MarkAll SP is missing!!

    I have activated the first of BizTalk SQL Agent jobs to backup all my BizTalk databases. The second step of this daily backup (MarkAndBackupLog) is failing. The first step (full backup) runs once a day at 4 AM and is succeeding. And the 3rd step of the backup job (clear history) is succeeding. But...

    XandersDad5 pointsBadges:
  • VB script to copy valid data to another file

    I am new to Scripting (Vb).  I need to do the following thru VB script. Is this possible? There are few VB scripts which is currently performing the file transfer function (transferring these files from the network drive to the application). Some times, this text file contain some junk data in...

    JaI825 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