Informatica - Hi All,I am loading a flat file into a DB2 database.My Session is succeeded but i am getting an erro

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 80 of 311

Hi All,
I am loading a flat file into a DB2 database.My Session is succeeded but i am getting an error like this
""WRITER_1_*_1> WRT_8229 Database errors occurred:
FnName: Bind Parameter -- [Striva ][ODBC DETAIL Driver] DTL-00264 DBAPI Error. DB_DESCRIBE failed for file TCCCATCN.;DTL-01252 DBNTC Initial OPEN CONVERSE failed to location "SYSD", rcs 0/2014/-204.;DTL-02006 SQL prepare error. SQLCODE = -204.; DSNT408I SQLCODE = -204, ERROR: AVIPB.TCCCATCN IS AN UNDEFINED NAME; DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE; DSNT415I SQLERRP = DSNXOTL SQL PROCEDURE DETECTING ERROR; DSNT416I SQLERRD = -500 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION; DSNT416I SQLERRD = X'FFFFFE0C' X'0
FnName: Bind Parameter -- [Striva ][ODBC DETAIL Driver] X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION;
Database driver error...parameter binding failed
"

Can anybody help me urgent, I need to deliver this by End of this week i.e, friday 29 sep 2006
plsssssssssss

Total Answers and Comments: 0

Last Update: September 27, 2006 Asked by: Sai

No answers are posted for this question yet.
Be the first to answer it!

Business Intelligence in Information Technology

Business Intelligence in Information Technology IT stands for Information Technology Information Technology is a system designed to gather process or distribute information IT can be inspected in terms of the following three groupings; the data gathering the data processing and the data distribut

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per

Performing XSLT Transformations inside the Database

Performing XSLT Transformations inside the Database Now that you have the employees XSL stylesheet stored in the database and the xmlusr schema is permitted to access the hr employees table you can create a script that will instruct the database to build an HTML page based on the data stored in hr e

Moving All the XML Processing into the Database

Moving All the XML Processing into the Database In the preceding example the database server performs only a part of the XML processing while the rest is still performed by the PHP engine Specifically the database server generates an employees XML document based on the records from the hr employees

Performing XML Processing inside the Database

Performing XML Processing inside the Database When building XML enabled applications on top of Oracle there are many advantages to performing the XML processing inside the database when compared to performing it on the client The key advantages to perform XML processing inside the database are as fo

ODP.NET - Working with Bind Variables together with OracleParameter

ODP NET Working with Bind Variables together with OracleParameter With the help of OracleParameter you can include bind variables within any SQL statement These bind variables are nothing but run time query parameters The values in the SQL statement are bound at run time when we use bind variables m

ODP.NET - Presenting Master-Detail Information Using a Dataset

ODP NET Presenting Master Detail Information Using a Dataset As mentioned before a DataSet object can have its own relations between data tables existing in it We can add these relations dynamically at the client side within an application to represent master detail or hierarchical information The f

ODP.NET - Retrieving a Single Row of Information Using OracleDataAdapter

ODP NET Retrieving a Single Row of Information Using OracleDataAdapter In the previous example we worked with a set of rows in the DataTable object Now we shall work with a particular row using the DataTable object The following code accepts an employee number from the user and gives you the details

jQuery Table Row Finished Code

jQuery Table Row Finished Code The Finished Code Our second example page has demonstrated table row striping highlighting tooltips collapsing expanding and filtering Taken together the JavaScript code for this page is mosgoogle geshibot lang php" document ready function var highlighted

No answers are posted for this question yet.Be the first to answer it!