• AS/400 : DB2/400 file override

    I have following scenario:- - in CL, override on PF to share ODP - Calling PGMx where above PF will be open using OPEN operation. - In PGMx,once file is open,calling another pgm(PGMy) to read the same file ( PF ) for specific record using READ operation (without SETLL ). Question : Record...

    Samule400160 pointsBadges:
  • best solution for integrating longitude and latitude into another Database in mySQL

    I have databases with longititude and latitude and one with Business Info - What is the best solution for getting the longitude/latitude into the Business Database? or Do I even need to merge them?

    Tcollins15 pointsBadges:
  • OSDB Connection to AS/400

    I am trying to connect the UPS Worldship to our AS/400 (V2r3). The data will download into the 400 file just fine when run separately. I have added a trigger to the physical file so that when a record is written to the physical file, an RPG program is initiated that updated several other files. If...

    Kkings0 pointsBadges:
  • resize contol in Access print view

    [table style="border-collapse: collapse; width: 347pt;" border="0" cellpadding="0" cellspacing="0" width="462"> [col style="width: 347pt;" width="462">[/cOLIST] [tr style="height: 69pt;" height="92"> [td class="xl63" style="height: 69pt; width: 347pt;" height="92" width="462">I am using ms access...

    Deepakpleo5 pointsBadges:
  • CPYFRMIMPF issue

    Okay, here's the deal. I've got a tab delimited file that used to load perfectly fine into file using the CPYFRMIMPF command, using the following options; CPYFRMIMPF FROMSTMF('/Directory of file/file.txt') TOFILE(Library/file) MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM(*NONE) RMVBLANK(*NONE)...

    Deaddancer0 pointsBadges:
  • SQL server production virtualization – to do or not to do

    I am being pushed to say yes for virtualizing our production server. We have already moved all our application servers, developement, stage and qa database environments to the virtualized environment (VMware). (These environments are not nearly the same size or power as production, can barely...

    ReluctantDBA5 pointsBadges:
  • Using Right() inside SQL Join

    I need to join two tables where one table uses 0809 as data in the field and the other table uses 200809. Can this be done? Can I use a Right() statement in the join? Thanks

    JeffCreek15 pointsBadges:
  • FAST ESP Stoarge requirements

    Hi, Have a quick question for all youfast experts :-) I work on the storage side and am looking at sizing my first fast esp storage. Talking to our fast guys ( and its their first implementation too) and I'm getting silly amounts of storage required, so was wondering if you guys can confirm. eg 1...

    Sanation995 pointsBadges:
  • Data migration strategies

    Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...

    Hazermark0 pointsBadges:
  • numeric test in SQL

    I have a complex select query and must now add an additonal condition. One of the elements must be numeric. The 'isnumeric' function keeps erroring out on me. select FWVCCOA_FMS_CENTER cfmsctr,        fwvccoa_fund_code  cfundcde,        fwvccoa_orgn_code  corgncde,       ...

    Sherryborden85 pointsBadges:
  • applications of rdbms in real world

    i need to know how rdbms is used in our real life with good example

    Chithra5 pointsBadges:
  • insert an access image into a crystal report

    A .bmp in a field on my access db; I want to display the image in my crystal report. I've looked at some forums but the suggestions don't getg me anywhere. any help would be much appreciated. Thank you

    Kims2125 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...

    ToddN200015,605 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:
  • Retrieval of Extended Source Library Information

    Is there a way via FTP to retrieve additional source code line-level details (sequence #, date line of code was changed) from iSeries RPG/CL source libraries? If not via FTP, is there another way to extract and transfer this information?

    Rchapin0 pointsBadges:
  • Help with converting Mainframe file on iSeries

    Hi there, I'm looking for some advice/help on a file that I'm having some trouble with. The file originates from a mainframe, and is sent over to our iSeries (V5R2M0) via Connect:Direct. The file is 3680 Bytes long, comprising of string and compressed numeric data. I have the layout of the file,...

    Nealhudson0 pointsBadges:
  • Edit .accdb from multiple workstations

    How can I input data in to a database file using microsoft access 2007 from multiple computers at the same time. From my understanding I need to have SQL Server running in order for me to do this, correct ? Also if I do need Sql server can it be installed on a Windows Xp Sp2 machine ?

    Tdizzle34230 pointsBadges:
  • The IT Blog Top 10: Dec. 10, 2009

    10. No Exchange 2007 on Windows 2008 R2 – but why? Brendan Cournoyer delves into why the latest Windows 2008 R2 takes a surprising turn in not support Exchange 2007. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8....

    ITKE352,565 pointsBadges:
  • The most-watched IT questions this week: Dec. 1, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. CompEng asked about open-ended SQL statements, and Mrdenny and Meandyou delivered the goods. 2. Kalpana queried Networking certifications, and where the best place is to get...

    Michael Morisy8,323 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE-2

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 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