Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by piterb

  1. piterb

    export data from Cobol data files

    Thank you all for help I stopped solving this problem because of deadline we have to make a deal with provider they give us piece of software which change this dat files into txt rapports and we process this. But when finish this I probably came back here :) Thank you once again
  2. piterb

    export data from Cobol data files

    mikrom I know about copybooks but unfortunately I don’t have any .cbl or .cpy files only a lot of .cob files. I am wondering if the structure can be stored in application source code webrabbit Nice idea but the problem is that application generates reports based on few files not just one so I...
  3. piterb

    export data from Cobol data files

    BP081005.DAT in fact has 277 records but records don’t have the same columns or 0F is not column delimiter , = 0F 1record – 259b, 5b, 5b, 5b, 5b, 5b, 453b, 5b, 5b, 5b, 5b, 5b, = 774b 2record – 259b, 5b, 5b, 5b, 5b, 5b, 25b, 5b, 5b, 5b, 5b, 5b, 25b, 5b, 5b, 5b, 5b, 5b, 25b, 5b, 5b, 5b, 5b, 5b...
  4. piterb

    export data from Cobol data files

    what do you mean by 'key'?
  5. piterb

    export data from Cobol data files

    I checked it and nothing… I even read whole file to byte table and try to read anything like this FileStream fs = File.OpenRead(@"C:\file.DAT"); BinaryReader br = new BinaryReader(fs); byte[] by = new byte[br.BaseStream.Length]; by = br.ReadBytes(Convert.ToInt32(br.BaseStream.Length))...
  6. piterb

    export data from Cobol data files

    Thx I will check it and see if I can use this info :) Maybe I wwill find size of the collumns Piter
  7. piterb

    export data from Cobol data files

    Thx for all your advices I checked most of them (still checking :)). “At the bottom of http://www.gip.com.pl/download/ReHot.pdf?tl=5 they write about daily and mothly reports in Excel format and about storing the statistics reports (daily and monthly) in central a SQL database.” - Yes but this...
  8. piterb

    export data from Cobol data files

    Vendor name is gip (unfortunately web site is in Polish so you wont be able to read it but I checked and there is only description of the software for customers, nothing for programmers :) ) Also I don’t have any record format of these files. If I had this format probably I wouldn’t need yours...
  9. piterb

    export data from Cobol data files

    Hello I have a problem. I need to export data from Cobol data files (dat, inx) to anything else (txt, cvs, excel access, whatever). I need to do this using C# and .NET platform. But I cannot open or read this files (I tried as flat file with fixed row size and separator, I tried different data...
  10. piterb

    Multi Join

    Thx for replay i have found this answer on different forum and it works so i wont check yours. Where clause joins are essentially INNER Joins so: from Pubs Example (line seperation for clarity only) (brackets may be optional) SELECT [Sales].[STOREID] AS Sales_STOREID, [Sales].[ORD_NUM]...
  11. piterb

    Multi Join

    Hello I am wondering if anyone can help me and tell me how to make multi join using TopSpeed ODBC Driver from C#. When I’m joining 2 tables it is OK but when I’m trying to add third table I have got an error "ERROR [42000] [SoftVelocity Inc.][TopSpeed ODBC Driver]Unexpected extra token: inner...
See more

Part and Inventory Search

Back
Top