• Access list

    I want to config a router to deny any use for TCP port 80. How can I do that?

    Asal15 pointsBadges:
  • Optical storage

    I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to...

    Rick1020060 pointsBadges:
  • Logical file to include only one of many matching records in secondaryu file

    I have a one to many relationship between 2 files. Although there are multiple matching records in the secondary file, the fields I am interested in are common. THerefore i only want one of the secondary records to join to the primary record - avaioding duplicate logical records. I know this could...

    JustinDouglas0 pointsBadges:
  • Alternate Collating Sequence

    I have a logical file keyed by email address and defined with ALTSEQ and dynamic select/omit. My problem is if I perform a READEQ for a specific key value, only records with lower-case keys are returned. I expected the upper-case entries to also be returned. Can anyone shed any light on why this...

    Intravler0 pointsBadges:
  • Pipe Delimited CSV File

    I have the following Pipe Delimited data in a physical file: Dealer Name¦Deal Number¦Buy/Sell¦ Joseph Camm¦80740¦S¦IG¦5000000.00¦ After issueing a CPYTOPCD command, I end up with: Dealer NameÝDeal NumberÝBuy/SellÝIG1ÝAMOUNT_amountÝ David CammÝ80740ÝSÝIGÝ5000000.00Ý How do I get...

    Ricca100 pointsBadges:
  • odbc data source

    odbc data source not displaying all dbs when pointing to sql2008. Only shows default db. odbc data source that points to sql2000 shows all dbs user has access to.

    Dowens20 pointsBadges:
  • 32 and 64 Bit SQL 2005 on Same Server

    We need to still link to MS Access databases and understand the 64 bit SQL Server does not allow. So, a thought is to have the new 64 bit SQL Server coexist with a 32 bit SQL Server Express instance. The thought is the 32 bit instance will enable linked server access to MS Access databases. We...

    MxPerry25 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:
  • Data Junction 7.0

    I'm attempting to use Data Juntion to create a reference table (DB4)from a proprietary database to use as input to a reporting appliation.  I need to create between 1 and 12 output records from each qualifying record from my database.  Is this possible in Data Junction?   Thanks!

    Gegrobe5 pointsBadges:
  • 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:

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