Re: Migration Problem EBCDIC to ASCII

try using the IEBGENER with the SYSUT2 DCB having OPTCD=Q I believe will convert it "to" ascii my sample is from ASCII to EBCDIC just switch the OPTCD in the ouput dd

george

//STP1 EXEC PGM=IEBGENER  00003000

     //SYSPRINT DD SYSOUT=*                                           
      00003100
     //SYSUDUMP DD SYSOUT=*                                           
      00003200
     //SYSABEND DD SYSOUT=*                                           
      00003300
     //SYSIN    DD DUMMY                                              
      00003400
     //SYSUT1  DD DSN=LP.GDF.COPY1,                                   
      00003500
     //           DISP=OLD,                                           
      00003600
     //           VOL=SER=735701,                                     
      00003700
     //           LABEL=(,BLP,EXPDT=98000),                           
      00003808
     //********   LABEL=(,NL,EXPDT=98000),                            
      00003908
     //***********LABEL=(,SL),                                        
      00004006
     //           UNIT=TAPE,                                          
      00004100
     //           DCB=(LRECL=160,RECFM=FB,BLKSIZE=9440,OPTCD=Q)       
      00004202
     //SYSUT2  DD DSN=CMEQGL.GEOFILE.Y1990,DISP=(,CATLG,DELETE),      
      00004300
     //******     VOL=SER=USER10,                                     
      00004407
     //           UNIT=CSDTSO,                                        
      00004507
     //           SPACE=(CYL,(10,5),RLSE),                            
      00004604
     //***********VOL=(,,,5),                                         
      00004700
     //           DCB=(LRECL=160,RECFM=FB,BLKSIZE=9440)               
      00004800
     

"Jens Junker" <J.Junker_at_kdt.de> wrote in message news:<a725q5$l58$1_at_news.kdt.de>...
> Hi,
>
> I am currently evaluating some szenarios to migrate a huge volume of data
> from an IBM host to a RS/6000 with an Oracle 9i database.
>
> Beside others,one of the problems is EBCDIC / ASCII conversion.
>
> Does Oracle 9i support a codeset which allows to store EBCDIC data on a
> RS/6000 with an Oracle 9i database?
>
> Many thanks
> Jens
Received on Thu Mar 21 2002 - 11:37:48 CST