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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fredericofonseca

    The new look....

    Thanks for hint. While better it's still bad - in order to see the messages we need to select the forum (or open on a new window), look at what's new, go back a page and so on.
  2. fredericofonseca

    The new look....

    apart from the "bad" look the available themes have, the biggest (and show stopper for me) is the fact that now we don't seem to have an option to have ONLY our subscribed forums on a compact list on the left which allowed us to quickly see what forums had new stuff, neither the option to them...
  3. fredericofonseca

    SSIS in SQL Server 2022

    SSIS is complex, very very picky with certain things, in many cases you need to use C# within SSIS to properly accomplish things, and most importantly it mostly for on-prem and requires a licensed SQL Server instance. better tools out there now than SSIS - even if not as easy, many of them are...
  4. fredericofonseca

    SSIS in SQL Server 2022

    first off if you are learning from scratch you would probably be better off learning some other ETL tool, both from MS or third party - SSIS it not a tool I would be keen to use going forward. with regards to SQL Server itself - SSDT was never truly part of SQL Server - but rather it is a...
  5. fredericofonseca

    SQL Performance

    views tend to behave badly in many cases - so avoid them. with regards to your particular code - renaming columns should not require temp tables - this rename can be done on the fly within the main sql - so if you need help on this please post the full code (and a actual explain plan as well) so...
  6. fredericofonseca

    Linkage Section Initialization

    reading manuals normally help. on those compiler vendors that do allow it the specification will normally be around this quote so for all intents the value within the linkage is ignored and it is what is supplied on the calling program parameters that is used. Regards Frederico Fonseca...
  7. fredericofonseca

    RM/COBOL data extraction

    Hi, not really feasible except on the most simple cases. if you have the full install you should have the above mentioned programs, mainly the rmmmapinx.cob - and if you do have a copy of the original client files you can run it over their files and see if they have compression enabled. If not...
  8. fredericofonseca

    RM/COBOL data extraction

    assuming that that is what you have installed on your installation and you have the full install it does help. if by any change the vendor also left behind the File definitions, either on a file, or on documentation, that would also help as interpreting the files after they are "converted" to a...
  9. fredericofonseca

    RM/COBOL data extraction

    thanks. its a file version 2, so possible to work with. Regards Frederico Fonseca SysSoft Integrated Ltd www.syssoft-int.com FAQ219-2884 FAQ181-2886
  10. fredericofonseca

    RM/COBOL data extraction

    can you also supply the first 20 bytes of the file Regards Frederico Fonseca SysSoft Integrated Ltd www.syssoft-int.com FAQ219-2884 FAQ181-2886
  11. fredericofonseca

    RM/COBOL data extraction

    ...resided (e.g. where the executable was installed) and see if there are further executables and other files there - namely some called recovery* - and if you do find a exe called runcobol try and execute it - should output version. if it won't work but if you do have a file called run.msg that...
  12. fredericofonseca

    RM/COBOL data extraction

    what is the exact cobol runtime version used to generate these files? and can you create a new set of files with dummy data and upload for us to look at? and do you have a valid runtime installation with all executables? there are utilities within it that may help "dumping" the data into a...
  13. fredericofonseca

    RM/COBOL data extraction

    don't reinvent the wheel. have a look at https://sourceforge.net/projects/record-editor/ while RM-COBOL is not mentioned as supported the use of Fujitsu Cobol as file type will work for most RM-COBOL file formats (for info Fujitsu bought a license to use RM filesystem format hence the...
  14. fredericofonseca

    Microfocus Cobol Compiler for personal use

    Microfocus still has a free version - works for 365 days and then needs renewal. https://www.microfocus.com/en-us/products/visual-cobol-personal-edition/free-trial you can also look into GnuCobol https://gnucobol.sourceforge.io/ and a IDE for it https://opencobolide.software.informer.com/4.6/...
  15. fredericofonseca

    Insert into query adds records to unreadable format, how do I change that?

    the collation should be according to the language you use Regards Frederico Fonseca SysSoft Integrated Ltd www.syssoft-int.com FAQ219-2884 FAQ181-2886
  16. fredericofonseca

    Insert into query adds records to unreadable format, how do I change that?

    ...Αγγελική','','','','','','','','','') , (N'EL00000001',N'000000000',N'Αθηνών',N'Ασημακοπούλου Αγγελική','','','','','','','','','') ; select * from #Customers Regards Frederico Fonseca SysSoft Integrated Ltd www.syssoft-int.com FAQ219-2884 FAQ181-2886
  17. fredericofonseca

    Eliminate pesky [ ] in SQL Management Studio

    nothing on SSMS to do that - only way is with some third party tools (like SQL Prompt) that have a option to "remove" the bracketes. Not all the other tools have this functionality. but do look for them - they are a must have for a sql developer - SQL Complete from Devart or SQL Prompt from...
  18. fredericofonseca

    Working Days giving NULL values

    ...as qtyused , pr.udfTopTier as toptier , ws.ScheduleNumber as schednum , m3wo.m3 as m3_wo , pa.ProductID /* sql below should really be replaced with a select from a calendar table (and the holiday table as well if those not defined on the calendar table) if...
  19. fredericofonseca

    Formula Advice

    if you use SQL to query that ERP system then why not do that split on the sql that retrieved the data - that way you have full control of what you get, you can get it in a readly usable number format, and you can even retrieve all other columns at same time on their own individual columns...
  20. fredericofonseca

    need to udate table entry with number containing a *

    Thanks Andy - corrected post. Regards Frederico Fonseca SysSoft Integrated Ltd www.syssoft-int.com FAQ219-2884 FAQ181-2886

Part and Inventory Search

Back
Top