Create Button to Open Specific Form
I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am [...]

Answer Question   |  May 22, 2013  2:27 PM
Access 2007, Access 2007 forms

Application retirement and database archiving
Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in Application DB, in DataMart I will have only [...]

Answer Question   |  May 22, 2013  10:06 AM
Application acceleration, Archive, Database, Database archiving, ETL, ILM

E-voting website
I intend to develop an internet voting website for my department to help with the departmental elections. How do I go about the programming aspect and the core part of database?

Answer Question   |  March 27, 2013  11:07 AM
Database, Database administration

About an OPCODE EVAL-CORR
I would like to have sample code on the OPCODE LIKEREC with all its parameters like with *All and *KEY and *INPUT and *OUTPUT. Also, I want to know whether OPCODE EVAL-CORR in iSeries or not  because when I want to transfer data from one DS (Data Structure) to another DS using EVAL-CORR, I’m getting [...]

Answer Question   |  February 8, 2013  4:27 AM
Data structures, iSeries

How to know whether the CSV extraction to PF happened today
I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the [...]

Answer Question   |  January 10, 2013  6:31 AM
AS/400, CSV, Physical File

How to implement a database on the users computer?
Suppose I want to develop a database for a client/firm/user or any person. I develop the DB using SQL, now I want to display the end result or the outcome on the clients computer without displaying the coded part, i.e., he/she doesn’t need to know about the codes and commands, he just manages db via [...]

Answer Question   |  December 26, 2012  3:16 PM
Database, Database Development

Take .csv files and show that on a subfile
Hi all, I am pretty new to this type of requirement. There are some .csv fiels in AS400 IFS follder. When user choose to the option – upload from the IFS folder from the menu, I need to show those .csv files as a subfile. From that subfile, user can select the csv file with [...]

Answer Question   |  September 11, 2012  12:35 PM
CSV

What’s your biggest data problem? (Answer to win a free book)
Data management is of growing concern now, and there are lots of ways to tame the beast.  What issues has your organization had with managing or analyzing data? Have you come up with any solutions yet? We’ll give a free copy of Making Sense of NoSQL (read an excerpt here) to the member who offers [...]

Answer Question   |  September 5, 2012  1:45 PM
Big Data, Data management, Database administration, NoSQL

Crystal Reports CSV with quotes inside string
I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: “Andy”, 4685, “requires 5″ by 2″ silver plate”, 1132 According to CSV standard it should be: “Andy”, 4685, “requires 5″” by 2″” silver [...]

Answer Question   |  May 24, 2012  4:26 PM
Crystal Report formula, Crystal Report XI, CSV

QEXECSQL command source
Hello, I am trying to implement a command ZCPYTOCSV. THis command uses ZFFDTOCSV and ZEXECSQL commands. I have the source of ZFFDTOCSV but cannot find the source for command ZEXECSQL. If anyone has access to this – could you please let me know. Alternatively is there is another better utility for copying Database file to [...]

Answer Question   |  May 27, 2012  9:37 AM
CSV, OS/400

Schedule SQL job to run and export to CSV file
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

Answer Question   |  May 8, 2013  11:45 PM
CSV, SQL Jobs, SSMS 2008

Writing to multiple fields with one text box
I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not [...]

Answer Question   |  February 28, 2012  2:20 PM
Access Database, Access query, Access Tables, MS Access 2007

Replace data in a text file using Access 2007
I need to replace data in a fixed length text file where the line number and position is always the same. Can anyone offer advice on this? Thanks in advance!

Answer Question   |  February 28, 2012  7:22 PM
Access 2007 functions, text files

Exporting a (.csv) file from SQL 2005
Hi, I’m trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have [...]

Answer Question   |  February 28, 2012  5:57 PM
CSV, SQL

Tie Access Query results to Form Entry
I am attempting to run a calculation based on the numerical values entered into the form. The end result would be to include the numerical value entered into the form as an item in a query equation calculation. Any help you can provide is greatly appreciated.

Answer Question   |  February 28, 2012  5:39 PM
Access 2007 forms

MS-Access data inserted in to Oracle 11g CLOB
I have an old MS-Access database storing data in bullet point format. I need to transfer this data across to an Oracle 11g EE database version at the same time maintain the MS-Access formatting.  How do I go about this?

Answer Question   |  November 15, 2011  4:08 PM
CLOB, formatting, MS Access, Oracle

I just narrowly avoided getting scammed (corrupted files)
I got a phone call from people impersonating some kind of tech support company. I was redirected to http://www.ammyy.com where I downloaded an .exe file which granted them remote control of my computer, and they then proceeded to use said program to run a scan for viruses, spyware and corrupt files. it was only when [...]

Answer Question   |  February 2, 2012  1:44 PM
Corrupted database, Remote access, Spyware, Viruses

Corrupt File on Windows Server 2003
Hello All, I just got this error on my Windows 2003 Server “the file or directory C:WINDOWSDebugUserModeChkAcc.log is corrupt and unnreadable. Please run the Chkdsk utility”. What do I do? Thanks All… Rgds, Jennifer.

Answer Question   |  March 31, 2012  9:09 AM
Corrupt Database, Data corruption, Windows Server 2003, Windows Server 2003 error messages

Lotus Domino Admins
Hi, We are using Lotus Domino 8.5 in our organization and now i need to create sub admins in the domino 8.5. It has options like system administrator , database administrator etc. Can someone please suggest

Answer Question   |  March 31, 2012  10:29 PM
Database administration, Lotus Administration, Lotus Domino, Lotus Domino 8.5

CGIConvMode BINARY – Help, I cannot make it working.
In the CGI, I use iconv() to translate all input/output from ebcdic to utf-8 (ccsid 1208) and vice versa for the body. For the CGI output Header I don’t process any translation, add x’15 twice to make a blank line. (as the HTTP default should make the translation from 37 to 819 for the http [...]

Answer Question   |  March 31, 2012  11:21 AM
Binary data, CGI, IBM i