Search results for query: *

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.

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...

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...

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...

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...

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...

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...

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...

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

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

see if you can find where the application 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...

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...

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...

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/...

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

you need to specify the strings as National strings e.g. N'X' drop table if exists #customers create table #Customers (custID NVARCHAR(200) ,custAFM NVARCHAR(200) ,custDOY NVARCHAR(200) , custName NVARCHAR(200) ,custProfession NVARCHAR(200) ,custHomePhone NVARCHAR(200) ,custMobilePhone...

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...

code formatted to be easier to read - and some comments added to it. as for why the nulls, the comments above already highlight what you need to look at. select pr.ProductCode , pr.Description , pso.StockLevelMin , pso.StockLevelMax , st.stockavailable ...

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...

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