![]() On Wed, mahendra_ghug.via informatica-l wrote: >I am new to mainframe systems and we have a requirement to extract data from VSAM file s. For al l the columns you should use iif(chrcode( =0, null, )) Thats the only difference, remaning things are same and the precision of the column should be almost double then the source port. Hi, Are you using power exchange or you are pulling it directly, if ur pulling it through power exchange then it is very similar to any ot her database table pulling except that you should check for occurance, if y ou want to it to be included in ur current table or just omit. ![]() ![]() ![]() Secondly make sure in the source file properites you check the following for the file infomation if the file is in Fixed width: click on advance->then check the binary radio button->use the file format of 'IBM EBCDIC US English IBM037' ->then put a '0' in the Number of bytes to skip btw recods text box. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |