How to move an AS/400 numeric field to an alphanumeric field without disturbing the value in it?

How to move a numeric field to an alphanumeric field without disturbing the value in it. I have a numeric field(9,2) with value MyVar = 9876543.21 I need to move this (as it is)into an alphanumeric field(12 A), without distorting the value in it. But if I use %CHAR, it gets moved along with...

svankipu625 pointsBadges:

How to disable auto audentity of a DB2/400 table

Hello, For a migration data project (from SQL/Server to DB2/400), we need to disable the auto identifiers of a DB2/400 table. On SQL Server, the equivalent command is "set identity_insert MyTable off". Thank you in advance JC Cherid

TheWorldAsGarp5 pointsBadges:

Transform DB2 to XML from AS/400

I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...

LBurkett99850 pointsBadges:

DB2/400: List of primary and foreign keys within schema

How can I get a list of primary and foreign keys within schema in DB2/400?

peterlk5 pointsBadges:

Certification sites for Synon?

Hello, Please can anyone suggest some good certification sites or courses for Synon or DB2 400. Except the ones from IBM. Synon is more broadly needed!!

Jammypune5 pointsBadges:

AS/400 – DB2/400 PF and LF have different identifiers for Synon

Hi, AS/400 -DB2/400--> PF and LF have different identifiers for files generated in Synon. But for the Manually created files PF and LF have same file level identifiers. Please let me know why it goes like this. Any idea? Looking answer for this. Thanks P.Amutha

As400pgmmer310 pointsBadges:

Convert AS/400 file to Excel and PDF

I would like to transfer a PF data into Excel but my add-ins not working. Can you provide me any other ways to do that?

As400programm10 pointsBadges:

We’re looking to add a field description in a DB2/400 file

My partner and I have a set of files on an AS/400 system but we don't have DDS for (the files were created in SQL). We would like to add field descriptions but we're struggling to find how to do this in AS/400.Could someone tell me how we can add a field description? Is directly updating...

ITKE1,127,730 pointsBadges:

Record format in DB2/400

How to check file name using record format in DB2/400?

vishwaraj60 pointsBadges:

Difference between logical join file vs. view

What is the difference between a Logical Join file and a view in DB2/400?

RBauer92525 pointsBadges:

[SQL0029] INTO clause missing from embedded statement.

HI, I have written lots of RPG/ILE & CL & COBOL programs in iSeries. I never worked on procedures & UDF. Now I'm learning these. I'm trying to create a procedure. This is the code. It's compiled without any errors. While running I got the below error. CREATE FUNCTION SUS.REWT(p_value...

HABBIE895 pointsBadges:

Converting from RPGLE to DB2/400 SQL

My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

SeaRancher5 pointsBadges:

Tuning DB2/400 queries on iSeries

We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?

AS400 - Ask the Expert485 pointsBadges:

Logical files – V5R4

Hi, we all know DSPDBR command on a PF will fetch all the dependent logical files. Can anybody tell me with a logical files name only known is it possible to fetch the Physical files name on whom it is dependent? Happy New Year and best wishes to all! Ram

ten20081,150 pointsBadges:

DB2/400 to Oracle 10g

I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration...

792755 pointsBadges:

AS/400 ODBC

Hi Our company uses AS/400 for our financial processing application. The users access the AS/400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in...

Pgsdeb20 pointsBadges:

How to find indicator and relative record number fields in DB2/400

In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...

BibinGeorge130 pointsBadges:

External DB2 Database link/trigger

In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.

r.otto810 pointsBadges:

Converting Data in Excel to PF on DB2/400

Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

rajsubhyd105 pointsBadges:

Multiple SQL statements through OLE DB on DB2/400

We have a third party application built on SharePoint, and we want to use DB2/400 on our System i for the application's backend database. The app uses ADO and OLE DB to query whatever database it links to, and the vendor has it working on a number of different databases, including DB2 on Windows...

AndyFarrar15 pointsBadges: