SAP 4.6c migration from MS SQL 2000 to IBM iOS DB2 database
Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol
Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol
5 pts.
How can i connect DB and input values in stored procedures using VBA
hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me....
hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me....
Create a view in DB2/400
I need an example to create a view in DB2/400. I Need to create a view where the table name is greather than 8 characters and collumns names greather than 6 characters. please somebody can help me??
I need an example to create a view in DB2/400. I Need to create a view where the table name is greather than 8 characters and collumns names greather than 6 characters. please somebody can help me??
export to csv file from java app
In windows our java application calls one .bat file which runs db2 export command to export data to csv file,how can i do the same on iseries...i dont have any knowledge of iseries and we need to deploy our application on iseries ...can anyone tell me how to do the same thing on iseries
In windows our java application calls one .bat file which runs db2 export command to export data to csv file,how can i do the same on iseries...i dont have any knowledge of iseries and we need to deploy our application on iseries ...can anyone tell me how to do the same thing on iseries
Export in db2 iseries
i want to export query output to a csv file on iseries ..can anyone tell me how to do that
i want to export query output to a csv file on iseries ..can anyone tell me how to do that
DB2 WebQuery: Metadata Error FOC1567
I'm new to DB2 Web Query. Just starting with the product. In metadata, I'm trying to pull in a DB2 SQL derived Table. I keep getting an error FOC1567. *LOCAL, <create synonym>, Table <only>, library / filename Error FOC1567 Create Synonym Data Source 'StockKeepingUnit' is not unique...
I'm new to DB2 Web Query. Just starting with the product. In metadata, I'm trying to pull in a DB2 SQL derived Table. I keep getting an error FOC1567. *LOCAL, <create synonym>, Table <only>, library / filename Error FOC1567 Create Synonym Data Source 'StockKeepingUnit' is not unique...
db2 os/390 v8 utility unload template parms
Hi, We are switching to use the unload utility from the unload program (dsntiaul). I would like to know how to use the template feature to allow multiple volumes to be used in the output. Since we use SMS to manage our storage devices and we want the output on dasd not tape, we normally can...
Hi, We are switching to use the unload utility from the unload program (dsntiaul). I would like to know how to use the template feature to allow multiple volumes to be used in the output. Since we use SMS to manage our storage devices and we want the output on dasd not tape, we normally can...
DB2 Select on a large number of rows/
I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the records I want to select for...
I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the records I want to select for...
DB2 Spufi output formatted
How do I get 2 lines of user specified headings using db2 SPUFI: SELECT A AS "LINE1 HDG" "LINE2 HDG" FROM TABLE doesn't work.
How do I get 2 lines of user specified headings using db2 SPUFI: SELECT A AS "LINE1 HDG" "LINE2 HDG" FROM TABLE doesn't work.
Find the DB2 Contoken
I have the load modules, can I look at them and find the DB2 CONTOKEN to match the package contoken?
I have the load modules, can I look at them and find the DB2 CONTOKEN to match the package contoken?
How to restrict QMF to execute predefined queries only?
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael
PL/I DB2Stored procedure Execution
How to execute the PL/I DB2 Stored procedure in Mainframe environment?
How to execute the PL/I DB2 Stored procedure in Mainframe environment?
DB2 Table Size in V6R1
Upper limitation of Table is 1.7TB in the V5R4 version. How about the limitation in V6R1?
Upper limitation of Table is 1.7TB in the V5R4 version. How about the limitation in V6R1?
COBOL date reformatting
I am getting a date from DB2 and I need to reformat it in COBOL. It will eventually be used in DOC1 so I need it to look like a date (i.e. with slashes or dashes). DOC1 was not recognizing the date I am passing in because right now it is just a numerical string, so I could not cast it as a date in...
I am getting a date from DB2 and I need to reformat it in COBOL. It will eventually be used in DOC1 so I need it to look like a date (i.e. with slashes or dashes). DOC1 was not recognizing the date I am passing in because right now it is just a numerical string, so I could not cast it as a date in...
DB2 and talend
I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 - A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error
I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 - A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error
DB2: Optimizer not using any indexes
I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?
I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?
XML-INTO
I'm trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header...
I'm trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header...
Need help with FILEAID in BATCH
I'm new to FILEAID, so I'd be grateful for some sage guidance on FILEAID command syntax's and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I'm trying (desperately) to create a work-around in...
I'm new to FILEAID, so I'd be grateful for some sage guidance on FILEAID command syntax's and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I'm trying (desperately) to create a work-around in...
Moving data from iSeries to DB2 on Windows
I need to get data from a iSeries DB2 system to my Windows DB2 system. The DBA produced and sent me a savf file. How can I important that savf file into DB2?
I need to get data from a iSeries DB2 system to my Windows DB2 system. The DBA produced and sent me a savf file. How can I important that savf file into DB2?
How can i connect Notes to AS400 (DB2)
Hello, i have a problem trying to connect our DB2 Database. I use DECS administrator to set up a connection-document to our AS400. To set up a connection-document i've used the instruction from IBM (http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408gupta/index.html) When clicking on...
Hello, i have a problem trying to connect our DB2 Database. I use DECS administrator to set up a connection-document to our AS400. To set up a connection-document i've used the instruction from IBM (http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408gupta/index.html) When clicking on...
