-
New Windows Server 2008 on network
I have a bunch of XP/Vista Home edition pc's that I will be upgrading or replacing with pro edition. In the mean time can these pc's access data on a windows 2008 server, even if it is just shared directories? Thanks
Last updated: -
Connecting a database in a linux system from a windows system through oracle 10g
hello sir/mam i have a linux server loaded with oracle 10g with so many databses. i want other windows systems to access the databases of server through oracle 10g. could u please explain me in detail how to make this set up.
Last updated: -
How do I create an ERDiagram from this table of information? Table=CUSTOMER- Customer_ID LastName FirstName Address PhoneNumber ContactNumber Email Address and add the following tables with this information: Table names: COSIGNEE -DRIVERS- PICKUPMANIFEST-DELIVERY_TRUCK_DETAILS-DELIVERY_MANIFEST
Last updated: -
Look up values from a table that refers to a range of records in Access 2007
My company is converting the account codes and I am verifying that each code has been assigned a new one. I was given 2 tables: 1 with current account codes, and the other provides the new code by range of current account codes. For example, if the current code is 1225, the conversion table would...
Last updated: -
Can I use filler to skip a column in a csv file on SQL*LOADER rel 8.0.6.3.0
We are running Oracle E-business suite 11.5.10.2 on db 9i but when I execute sql*loader it gives me version 8.0.6.3.0. Is the key word FILLER available for me to use to skip unwanted columns in a comma delimited input file? I know FILLER became a key work in 9i - is that the db 9i? Why is my...
Last updated: -
I have an application where a start form, launches a second one and then according to text input/selection more form open (as a 3rd level form). I want all the answers to be recorded in one table as a singe record, but instead I get 3 different records, with responses from each form. What do I...
Last updated: -
RPG with Embedded SQL needs journaling
When I try updating data in a PF via embedded SQL I get a message saying I need to turn journaling on.. * change dates on a set of records C/EXEC SQL C+ UPDATE ACC02602P C+ SET CSSTR8 =...
Last updated: -
Keep the “first” value using groupby – MYSQL
Input : col1 col2 a 1 b 1 c 2 d 2 I would like to : Create the new colX to get the first value in col1 group by col2 and save the value in colX results : col1 col2 colX a 1 a b 1 a c ...
Last updated: -
search string in oracle DMP file
hi , i would like to write a pl/sql oracle code to search a string from Oralce DMP file. e.g <OWNER_NAME>[strong]xxx[/strong]</OWNER_NAME> i want to get [strong]XXX[/strong] as output . any help would be really really appreciated
Last updated: -
iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...
Last updated: -
Hi, Being an AS/400 development/admin guy what are the roles and responsibilites of DB2/400(DB/400 ?) on daily basis. What could be the maintenance activities. I'm just curious about to know...waiting for your valuable comments..
Last updated: -
Getting prompted for userid/password when viewing Crystal Reports
Connections are ODBC Oracle. You can see a pic of what I am talking about here: This happens for every report on the server. Everyone uses the same login and password so I wish there was a way this wouldn't bug the user.s
Last updated: -
I am trying to print a small card we call a buy card. I recieve an error The Printout action was canceled. I can print normal size paper fine.
Last updated: -
How do I update the value of one row with the value of a different row? i want to build an expression For example: I have 3 columns. If Column 1=C and C is Null, then I want the values for C in Column 2 to = 10000 (the value from Column 2 for A) and the values for C in Column 3 to = 22000 9the...
Last updated: -
how cna i connect mysql database with my login form using jsp in linux operating system?
Last updated: -
How to convert a a string date to date time format
how to convert a a string date to date time format
Last updated: -
HI, When I try to delete a journal receiver that hasn't been saved, I get the "never fully saved" message even though I'm using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached...... Thanks
-
Importing/copying external EBCDIC files to DB2 on iseries
This seems kind of obvious, but we can't figure it out. Another company has sent us (via email) an EBCDIC file and we want to load it on to our iseries. What's the ticket? We've tried CPYFRMPCD and a couple of other things, but we get conversion errors? Any thoughts out there?
Last updated: -
Combo Box Selection Locks Form
I have a combo box that locks/corrupts all of the controls on a Access 2003 form. The locking symptom only seems to occur when the list index is greater than 0. The problem control may not be the combo box. It may be one of two list boxes that are affected by the combo box's 'after update'...
Last updated: -
Disaster recovery for SQL 2005
How can we setup a disaster recovery sql server? We are running SQL 2005 on a 2003 box. We need a real time exact replica we can switch to?
Last updated: