In my project source data comes from MAINFRAME in
files.so,This time data is coming as a binary file...I know
for binary data we use Complex flat file stage..I have used
it also..but on 'view data' data is not coming
correctly..as it in MAINFRAME.give me some ideas..
Answers were Sorted based on User's Feedback
Answer / hussy
To read a Mainframe file you need a copybook of that file.
what I mean to say is metadata of that particular file. As
it will be in the cobol format (where levels are defined).
But there is possibility of reading Mainframe file without
using copybook but needs lot of effort.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dhrubajyoti ghosh
just give me some sample data like mainfrem file
or u can pares data 1st with the help of shell scripts
into a flat file
| Is This Answer Correct ? | 1 Yes | 1 No |
What is Horizontal transformation, vertical transformation,diagonal transformation?
how to call sequential generator in datastage?
What are the repository tables in datastage?
What is the use of datastage director?
how can you generate sequence number using only the sequential file stage?
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
Which type of joins Merge stage can support?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
How do u call shellscript/Batch file from DS?
what is diff b/w datastage 8.1,8.5,8.7?
1)How to Duplicate Records Delete in Sequential file?