Using the BLOB datatype
IT HAS BEEN CLEARED THAT TO INSERT THE IMAGES INTO ORACLE DATABASE, A COLUMN WITH DATATYPE BLOB HAS TO BE CREATED IN THE TABLE, PLEASE TELL ME HOW TO INSERT AND RETRIEVE THE IMAGE INTO AND FROM THE DATABASE RESPECTIVELY. THANKS, SIMRAN.
Answer Question
| August 25, 2008 5:01 AM
BLOB, Oracle development
IT HAS BEEN CLEARED THAT TO INSERT THE IMAGES INTO ORACLE DATABASE, A COLUMN WITH DATATYPE BLOB HAS TO BE CREATED IN THE TABLE, PLEASE TELL ME HOW TO INSERT AND RETRIEVE THE IMAGE INTO AND FROM THE DATABASE RESPECTIVELY. THANKS, SIMRAN.
Answer Question
| August 25, 2008 5:01 AM
BLOB, Oracle development
Oracle to SQL Server Migration – CURSOR type conversion
When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.
Answer Question
| August 25, 2008 1:42 AM
Database migration, Oracle import/export, SQL Server 2005, SQL Server import/export, SSMA for Oracle
When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.
Answer Question
| August 25, 2008 1:42 AM
Database migration, Oracle import/export, SQL Server 2005, SQL Server import/export, SSMA for Oracle
Oracle to SQL Server Migration – User Defined data types
Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks
Answer Question
| August 28, 2008 1:38 AM
Database migration, Oracle import/export, Oracle migration, SQL Server 2005, SQL Server import/export, SSMA for Oracle
Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks
Answer Question
| August 28, 2008 1:38 AM
Database migration, Oracle import/export, Oracle migration, SQL Server 2005, SQL Server import/export, SSMA for Oracle
Problems with the SQL query function
I am designing a website, and I’m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command “select * from table where ref_id=’1001′,” it returns 1002, 1003 and 1004. [...]
Answer Question
| August 22, 2008 4:16 PM
Query, SQL, tables
I am designing a website, and I’m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command “select * from table where ref_id=’1001′,” it returns 1002, 1003 and 1004. [...]
Answer Question
| August 22, 2008 4:16 PM
Query, SQL, tables
Why sqlcode error=100 comes ?
sqlcode error=100 comes. The required fields are being populated in table. Still why i am getting this error ?
Answer Question
| August 21, 2008 3:58 PM
Informix, ISAM, SQL, sqlcode error=100
sqlcode error=100 comes. The required fields are being populated in table. Still why i am getting this error ?
Answer Question
| August 21, 2008 3:58 PM
Informix, ISAM, SQL, sqlcode error=100
Access database management
Hi guys I am managing a database and need to know if there is away of moving ‘completed’ records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having this [...]
Answer Question
| August 21, 2008 8:30 AM
Database, Database programming, Microsoft Access
Hi guys I am managing a database and need to know if there is away of moving ‘completed’ records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having this [...]
Answer Question
| August 21, 2008 8:30 AM
Database, Database programming, Microsoft Access
SQL insert statement
Hopefully there are some ASP experts put there who can help me. I am trying to write an SQL insert statement to populate an access database from an HTML form. When I submit the form, I am getting page cannot be displayed with the following error message: Error Type: Microsoft VBScript compilation (0x800A0400) Expected statement [...]
Answer Question
| August 20, 2008 6:08 PM
ASP, INSERT statement, SQL
Hopefully there are some ASP experts put there who can help me. I am trying to write an SQL insert statement to populate an access database from an HTML form. When I submit the form, I am getting page cannot be displayed with the following error message: Error Type: Microsoft VBScript compilation (0x800A0400) Expected statement [...]
Answer Question
| August 20, 2008 6:08 PM
ASP, INSERT statement, SQL
processing biometric data
can biometric data be incorporated into desktop or stand-alone applications like ms excel and ms access?
Answer Question
| August 21, 2008 5:40 PM
Biometrics, Microsoft Access, Microsoft Excel
can biometric data be incorporated into desktop or stand-alone applications like ms excel and ms access?
Answer Question
| August 21, 2008 5:40 PM
Biometrics, Microsoft Access, Microsoft Excel
Switch/Case statment in access
how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow: Field Name: Directions in this field i need to write codes like: TAm Field Name: Translation here i need to read TAm as T=Take, Am= Morning. the problem i have more than 200 codes, which they have to be [...]
Answer Question
| August 25, 2008 11:10 AM
Access 2003, CASE statement, Database programming, Microsoft Access
how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow: Field Name: Directions in this field i need to write codes like: TAm Field Name: Translation here i need to read TAm as T=Take, Am= Morning. the problem i have more than 200 codes, which they have to be [...]
Answer Question
| August 25, 2008 11:10 AM
Access 2003, CASE statement, Database programming, Microsoft Access
Embedded SQL in RPG ILE
I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven’t figured out is how to code the fetch statement to populate variables that aren’t known until execution time
Answer Question
| November 5, 2008 11:15 PM
Embedded SQL, iSeries, RPG, RPGLE, RPGSQL
I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven’t figured out is how to code the fetch statement to populate variables that aren’t known until execution time
Answer Question
| November 5, 2008 11:15 PM
Embedded SQL, iSeries, RPG, RPGLE, RPGSQL
Microsoft Access export to Excel changes values
I have a table populated through a form using lookup tables. When this table is exported using “right click,export” to excel or dbase, the values appears increased by 1. For example 0 appears as 1, 1 as 2. When just copy and paste, it does not happens
Answer Question
| August 20, 2008 10:04 PM
Microsoft Access import/export, Microsoft Excel, Microsoft Excel import/export
I have a table populated through a form using lookup tables. When this table is exported using “right click,export” to excel or dbase, the values appears increased by 1. For example 0 appears as 1, 1 as 2. When just copy and paste, it does not happens
Answer Question
| August 20, 2008 10:04 PM
Microsoft Access import/export, Microsoft Excel, Microsoft Excel import/export
Overlapping data on a merge replication between three SQL Servers
We have a merge replication between our three SQL servers at three different locations. One is the publisher and two are subscribers, and we have a primary key on a table (a unique field with is auto-incremental by one). On the publisher’s server, if the user creates a new order, the table assigns it a [...]
Answer Question
| August 19, 2008 8:04 PM
Merge replication, Primary keys
We have a merge replication between our three SQL servers at three different locations. One is the publisher and two are subscribers, and we have a primary key on a table (a unique field with is auto-incremental by one). On the publisher’s server, if the user creates a new order, the table assigns it a [...]
Answer Question
| August 19, 2008 8:04 PM
Merge replication, Primary keys
is there anything in SharePoint that we could use to exchange data or hook into Visual Source Safe 6.0?
VSS and SharePoint 2007: From what I understand, Team Server 2008 uses the SharePoint platform. Our team has already committed to making a WSS 3.0 SharePoint website and will not be investing in Team Server. I am wondering – is there anything in SharePoint that we could use to exchange data or hook into Visual [...]
Answer Question
| August 19, 2008 2:45 PM
SharePoint, SharePoint 2007, Visual Source Safe, VSS, Windows Server 2003
VSS and SharePoint 2007: From what I understand, Team Server 2008 uses the SharePoint platform. Our team has already committed to making a WSS 3.0 SharePoint website and will not be investing in Team Server. I am wondering – is there anything in SharePoint that we could use to exchange data or hook into Visual [...]
Answer Question
| August 19, 2008 2:45 PM
SharePoint, SharePoint 2007, Visual Source Safe, VSS, Windows Server 2003
hired by a company using AS/400
i know that most of you dont have time to answer but it is important for me to know what to expect using AS/400…i just finished a networking course (mostly MS, and intro to Linux admin.) Is their anything important that can help me.
Answer Question
| August 20, 2008 3:01 AM
AS/400 careers, Career development, IT careers
i know that most of you dont have time to answer but it is important for me to know what to expect using AS/400…i just finished a networking course (mostly MS, and intro to Linux admin.) Is their anything important that can help me.
Answer Question
| August 20, 2008 3:01 AM
AS/400 careers, Career development, IT careers
How to show list view in Microsoft Access report
i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how’s the coding?
Answer Question
| August 18, 2008 9:42 AM
listview, Microsoft Access, VB, Visual Basic 6
i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how’s the coding?
Answer Question
| August 18, 2008 9:42 AM
listview, Microsoft Access, VB, Visual Basic 6
Has the job market in IT gotten older?
I’m 54 years old this Novemeber 2008, and I have been on a travel escapade in Canada for 2 1/2 years and am ready to come home to San Diego, CA. I was doing routers, switches, PIXs, Bluecoat, Squid boxes, Help Desks, Exchange 5.5 and just into Exchange 2000 and pretty good at Linux, too. [...]
Answer Question
| August 16, 2008 1:36 AM
Career development, IT careers, Job, Networking, Networking careers, Training
I’m 54 years old this Novemeber 2008, and I have been on a travel escapade in Canada for 2 1/2 years and am ready to come home to San Diego, CA. I was doing routers, switches, PIXs, Bluecoat, Squid boxes, Help Desks, Exchange 5.5 and just into Exchange 2000 and pretty good at Linux, too. [...]
Answer Question
| August 16, 2008 1:36 AM
Career development, IT careers, Job, Networking, Networking careers, Training
How can I switch into the networking field from a software development background?
I completed my engineering in branch IT, but now I don’t want to go into the s/w (software) field. I’m much more interested in networking and hardware. What are my options for switching over?
Answer Question
| August 16, 2008 1:29 AM
branch IT, Engineers, IT careers, IT training and certifications, Networking, Software development
I completed my engineering in branch IT, but now I don’t want to go into the s/w (software) field. I’m much more interested in networking and hardware. What are my options for switching over?
Answer Question
| August 16, 2008 1:29 AM
branch IT, Engineers, IT careers, IT training and certifications, Networking, Software development
Fast Entry SAP HR
Is there a fast entry in SAP HR for entering multiple employees for layoff
Answer Question
| August 15, 2008 9:01 PM
IT careers, SAP careers
Is there a fast entry in SAP HR for entering multiple employees for layoff
Answer Question
| August 15, 2008 9:01 PM
IT careers, SAP careers
How do I retrieve the most recent date from an access database
I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.
Answer Question
| August 18, 2008 5:29 PM
Access 2003, Access Database, Microsoft Access
I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.
Answer Question
| August 18, 2008 5:29 PM
Access 2003, Access Database, Microsoft Access
Reindex DBF file from Ms-SQL 2000
Is it possible to reindex an extenal dbf file via linked server ?
Answer Question
| August 18, 2008 9:51 PM
DBF file, Linked servers, SQL Server 2000
Is it possible to reindex an extenal dbf file via linked server ?
Answer Question
| August 18, 2008 9:51 PM
DBF file, Linked servers, SQL Server 2000
