Sybase substring jobs

...programming, and designing fault-tolerant distributed applications. Experience in building distributed applications using SQL and/or NoSQL technologies (e.g., MS SQL, Sybase, Cassandra, or Redis). Design and build scalable services using API-First principles (REST/gRPC). Exposure to Docker, Kubernetes, and cloud services is a plus. Analytical and software architecture design skills with an emphasis on test-driven development. Effective communication skills in English (written and verbal). Bachelor’s or master’s degree in computer science or engineering preferred. Technology & Tools: Technologies involved: C#, .Net Core MSSQL, Sybase, Cassandra, or Redis React / JavaScript Docker, Kubernetes, and cloud services Agile (Scrum) Support tools: Microsoft Teams...

Project Description: Sybase Performance Optimization and Troubleshooting I am looking for a skilled freelancer who can help me with a performance-related task for my Sybase database. The specific issue I am experiencing is memory leaks, which is causing performance degradation. Skills and Experience Required: - Strong expertise in Sybase database administration and performance tuning - In-depth knowledge of identifying and resolving memory leaks in Sybase - Experience in optimizing Sybase performance and troubleshooting performance-related issues - Familiarity with query optimization techniques and best practices - Ability to analyze and diagnose performance problems in Sybase - Proficiency in generating detailed reports on the issue and providin...

...hacking, monitoring, including having worked with or for any person or organization that engages in such activities, please do not bid on this job; the company has a very strict no intrusion policy and does not allow this. I want a developer who is familiar with WKWebView to detect if the URL from the webview starts with a specific substring, and if so, launch an In App Purchase window of a specific product determined by the name of the product found within the substring of the URL. Pretty easy and fast job. I already have the app working with WKWebView. No database nor storage integration is required, just these lines of code in SWIFT, or whatever other language may be compatible. Additionally, I want a request to check the status of the subscription -- all that is need...

I am looking for a Power BI expert who can help me extract a substring from a text column and display it in a custom column. The ideal candidate should have experience with Power BI and be familiar with the following requirements: - Extracting a substring from a specified text column - The text column to extract the substring from is "TEXTO" - The desired substring to extract is "(123) cargos" - Displaying the extracted substring in a custom column named "Cargos" - The extracted substring should only contain the number in parentheses, i.e., "123" If you have experience with Power BI and are confident in your ability to fulfill these requirements, please submit your proposal.

I have a database app on my phone called memento. I have a piece of code I wrote to send an sms directly from the database when you tap on a button and when it see s a date field it sends it like this Thu Oct 12 2023 16:14:53 GMT=1100(ADET) I was hoping if I use substring it would trim the date down to something like this Thu Oct 12 2023 However in my code that I have attached it gives and error saying "cannot call method of substring in object Thu Oct 12 2023 16:14:53 GMT=1100(ADET)" can someone take a look at my code and see what I am doing wrong please

...GNC_QRP_ShippingPictures pic WHERE CONVERT(DATE, ) = @BoxedDate; -- Retrieve missing picture data from the main table SELECT sd.ORDNUM_28, sd.LINNUM_28 FROM so_detail sd inner join Part_Sales ps on sd.PRTNUM_28 = ps.PRTNUM_29 LEFT JOIN #TempTableQRP sp ON sd.ORDNUM_28 = AND sd.LINNUM_28 = WHERE substring(ps.SLSCAT_29,1,1)<> '*' and substring(ps.SLSCAT_29,2,1)<> '*' and substring(ps.SLSCAT_29,1,1)<> ' ' and sd.ORDNUM_28 IN ( SELECT DISTINCT OrderNumber FROM GNC_QRP_ShippingPictures WHERE CONVERT(DATE, BoxedDate) = @BoxedDate ) AND IS NULL AND sd.DELNUM_28 = '01'; -- Drop the temporary table DROP TABLE #TempTableQRP; END; Outp...

I am looking for a skilled freelancer to help me convert my Sybase 17 database to SQL Server 2019/2022. The database is less than 1 GB in size and I have already installed and configured SQL Server. There are no specific customizations or features that need to be preserved during the conversion process. However, all schema and data must be converted over to SQL Server. I am open open to using a 3rd party utility or custom scripts that will perform this process. Validation in the form of schema and data row comparison between source (Sybase 17 db) and Destination (SQL Server db) must be part of the delivery. *********************************** Again, I encourage and open to use 3rd party conversion utilities such as Microsoft SSMA, ETL tools etc.. to manage this conversion. T...

I am experiencing a data updating issue with my Sybase database and require assistance from a skilled freelancer. The issue pertains to the entire database and not a specific table. The frontend programming language is unspecified, and I need someone with knowledge and expertise in resolving Sybase database issues, familiar with the following: - Sybase database management - .NET framework - Troubleshooting data updating issues Specifics: Eaglesoft is a software application for dental offices that uses SQL Anywhere. I created another application which retrieves and updates data in Eaglesoft database which is Sybase. In my application I modify appointment records in the DB to set them as confirmed by the patient. I can do "select * from table" and ...

I am in need of a freelancer who can provide support on Netezza Administration. The support is needed within a few days and will require a full day (8 hours) of work. The ideal candidate should have experience in Netezza & Sybase Administration and be able to provide immediate assistance when necessary.

=================================================================== Please - do not apply if you are not a real Matlab developer - the project will be paid in ONE milestone when finished and working on m yside =================================================================== Hi, I have ..."insert_marg.m" script to read all the files of the Zip below 3) check the DB to see if the data has been inserted correctly 4) In "RalusRaws" databse table: - check that column MSGID and RECTIME hold correct data (and are not interchanged: compare with the text file) - check that each of the 3 files write data in the correct columns and missing columns in each file are left empty in the databse - substring column names in data field for files *.stk and *.tcr files 5) substit...

Need to build project with Springboot batch with @scheduler. Where reader must be sybase

I am looking for an experienced database architect to help me build a new DWH database on MS-SQL tailored to my specific business needs. The source data will need to be get from Sybase. Working with Microsoft SQL Server and Microsoft BI reports, the database architect will be responsible for helping set up the best architecture / structure of the different data to be analysed and manipulated The different data are mainly financial related. The primary duties will include setting up the database, designing the Data Warehouse, and implementing Microsoft BI systems. The ideal candidate should have strong experience in database design and implementation. Expertise in relational database management systems, Microsoft SQL Servers DWH, and BI Reporting Systems is with the technical

Need a Power BI developer to migrate reports from Cognos to Azure Power BI. Source data available in Sybase Tables. Knowledge on 1. Sybase 2. Azure 3. Cognos 4. Power BI

I have a .db file created with a program that works on SQL Anywhere (Sybase). What is needed: Ability to open the .db file and move it to MySQL / any other readable format Any reply without: " I am familiar with Sybase and I know how to open a .db file " will be ignored

PYTHON: I have a folder containing a lot of .json files. I want to edit all of these json by adding a new key and values like Original json: {"type":{"version":"1.0","name":"TEXT"},"value":{"OLD_KE...{"type":{"version":"1.0","name":"TEXT"},"value":{"OLD_KEY1": "OLD_VAL1", "OLD_KEY2": "OLD_VAL2", etc Desired json after update: {"type":{"version":"1.0","name":"TEXT"},"value":{"NEW_KEY": ["NEW_VAL1", "NEW_VAL2", "NEW_VAL3", "NEW_VAL4", "NEW_VAL5", "NEW_VAL6", "NEW_VAL7"],"OLD_KEY1&...

We have to change the static ip address of Unix OS based local server which runs sybase software for data processing. We also want to connect multiple terminals to the main server to enable data punching from multiple sources

Hi, I have a body of text, I want a substring to be found and output from there, it is dynamic but starts and ends with a static pattern.

Manual and automated testing of the client-server software applications *W...Automation Assurance we expect from you: Mastery of various principles, methodologies and methods of testing. Creation of software testing documentation. Ability to independently adjust and maintain the process of product quality control. Working with the bug tracking system (BugZilla, Jira). Working to ensure the quality of web and mobile services. Databases: Oracle, MS SQL Server, PostgreSQL, Sybase. Working with a version control system. Working with Git or Bitbucket. English Upper-Intermediate level and above. *Will be a plus: Experience in testing web-applications. Experience in writing automated tests (Java or Python). Experience in automating API testing (Postman, Newman, etc.). Ability to work wit...

I need help using suffix tree to find the longest common substring, Python. i will send more details in the chat.

Looking for a lead PM who can support testing AWS -S3 project. Primary task is to work with DBA’s to Setup SQL server qual environment. Set up replication in sybase environment. Create new and dedicated credentials for DMS to use on prem with the source servers. Set up fire walls. In general, I am looking for some one who is exceptional in AWS S3 implementation and testing. This is an ongoing project for one month.

... and returns the top X matches based on the request. This is effectively a fuzzy search system that tries to find a CPE for an application version, should one exist in the dictionary. This could be a problem resolved by a machine learning model, natural language processing, and/or distance algorithms. As guidance, the API could use Levenstein, keyword counting, Jaccard index, longest common substring, Hunt–Szymanski algorithm, Hamming distance, Damerau–Levenshtein, or a combination of the aforementioned algorithms. The selected algorithms should be used to find a match for the POSTed application in the CPE dictionary () should one exist. The microservice/REST API itself is very simple. No authentication or security controls. Only one interface to POST the

Looking for sybase to Oracle DB migration. Skill set with hands on knowledge. Expert level. .

Below are the details of the training Technology- Sybase Training Participants : Both Laterals and freshers No of Pax : 25 Table of Contents :  SYBASE General Administrative tasks SYBASE manual DB backups SYBASE DB restore SYBASE password changing for users SYBASE DB refresh SYBASE Stop and start in HA and Cluster environment SYBASE Licensing SYBASE Housekeeping tasks Troubleshooting, Performance Tuning, Optimization. Configuring & Maintaining database servers and components. Monitoring of system health and performance, to ensure high levels of performance, availability, and security. Monitoring database and replication servers for resource utilization. Testing, reporting, backup/restore. Manage...

1. Installation of Sybase database 2. Restoring/importing database backup file 3. using different tools as part of sybase db.

I have a function and a stored procedure return in MSSQL, I need a Sybase (T-SQL) expert to convert the function and procedure. I have attached the bot function and Stored procedure. This is a straight requirement. I have clearly gave the budget of the project and don't discuss or bargain on the price max is 50$. I am a MSSQL expert and I know the timeframe for the task involved.

Currently we export and import ASE database table manually. We are looking for a customized script to export and import specific ASE database table.

We need to configure Sybase and restore a db, so we can convert it to SQL server. We now have problems with configuring the network

...SWISS-PROT database 2) mcg: McGeoch's method for signal sequence recognition. 3) gvh: von Heijne's method for signal sequence recognition. 4) alm: Score of the ALOM membrane spanning region prediction program. 5) mit: Score of discriminant analysis of the amino acid content of the N-terminal region (20 residues long) of mitochondrial and non-mitochondrial proteins. 6) erl: Presence of "HDEL" substring (thought to act as a signal for retention in the endoplasmic reticulum lumen). Binary attribute. 7) pox: Peroxisomal targeting signal in the C-terminus. 8) vac: Score of discriminant analysis of the amino acid content of vacuolar and extracellular proteins. 9) nuc: Score of discriminant analysis of nuclear localization signals of nuclear and non-nuclear proteins....

Assist with repairing the installation of Sybase 16.0 which has some config issues on Windows 10 using either Zoom or Team Viewer while you have keyboard control. Please describe your Sybase 15.7 or Sybase 16.0 experience and describe what types of configuration and installation issues you have fixed previously. Then install the sample databases available from SAP. Complete the creation of the Backup Server and show me how to access the tables using iAnywhere. Your English language skills should be very strong.

Roles and Responsibilities: * ...customer support of the ERP software written in Powerbuilder with backend of SQL Server/Sybase. * Develop programs, reports, test, and enhance the software as per specifications given by management team. Desired Candidate Profile * Should have good hands-on experience in PowerBuilder 8 or above along with decent experience of database/SQL. * Experience writing functional and technical specifications, user and technical documentation. * Should be able to work under a team framework and willing to work in dynamic environment with changing priorities and assignments. * Ability to drive projects to completion on time. * Should have at least 2+ Years of experience as Developer at PowerBuilder/SQL Server or Sybase. * Good to have strong ...

I am using a language that looks a lot like C# and I am looking for someone to help me write some simple functions in that language. The functions will be simple: count the number of characters in a given string, check if a substring is present in a given string, etc. You must be available to start now and finish asap. Background in maths is also helpful.

Hello, i need the cpde to transform this example string: _be7ddee5dc28e7da66095fa45f1d0005.www.domain.com. to: domain.com. can be another text but always be the same style ( dominio.es. or google.org. ) Conditions: - Inmediatly deliver - Simplest code (no function, no regex), no modules. Only native functions like substring or indexof

3 - 8 years of experience with Java. 2. Minimum 2 year of experience with any SQL database (MySql, MSSql, Oracle, DB2, Sybase). 3. Minimum 3 years of experience with web development. JAVA Developer(Backend) 2 4. Experience with any NoSql database (MongoDb, Couchbase, CouchDb, DynamoDb). 5. Experience of designing/implementing/maintaining scalable distributed systems. 6. Experience with any cloud platform (AWS/Azure/GCP). 7. Experience with Kafka and Spark. 8. Experience with SpringBoot.

I have the file "Sybase SysMon Report ", which I need to convert into two reports: 1. "Sybase SysMon Usage information 20220207 " 2. "Sybase SysMon Usage information 20220207 " Details enclosed in file Required: - Use bash script (*.sh) to be executed from Linux and get the final expected reports.

I have a list of 50 thousand product codes in a file. In another file I have a list of 1000 product descriptions. Product description is a group of words, like a sentence, and contains the product code in it, but not in a specific location. It could be in the starting, ending, or in middle. I want a macro that...like a sentence, and contains the product code in it, but not in a specific location. It could be in the starting, ending, or in middle. I want a macro that can search for the product code in the description and if found, copy the code to a new column beside the description. The trick here is, one product code can be a substring of the other. For example, there are 2 product codes, 569 and 1025693456. when we are searching for 569, we cannot map it to 1025693456 as it is a ...

Hi All, I need to connect to remote sybase database from laravel. Need instructions how to configure Sybase on Windows machine + sample code and instruction how to do it from laravel side

The 20-line Google script below is to remove all rows in Sheet1 one that in any column substring-match any value inside column A on Sheet2. It's not working correctly. When you run the script once, the row with the value "ccc" in Sheet1 is still there even though it "c" is one of the values inside column A in Sheet2. I'm looking for a fix to the script. I have $50 for this if you can turn this around in one hour. Below is a link to a public sheet you can copy. Thanks. https://docs.google.com/spreadsheets/d/1_BAoHzV2v9BIiaPdbjKhd8JD_ChsJzfpo1lsgYRPBMA/edit#gid=0 Script: function onOpen() { const ui = (); ('Functions') .addItem('Unsubscribe', 'est_unsubscribe') .addToUi(); } function est_unsubscribe() ...

I want someone to edit on software built with power builder and sybase sql I want to add feature in the program but I don’t have the source code but i have installation files

• Company – Nextbridge IT Solutions Pvt Ltd • Primary Projects will be related to Avaya IVR,Custom WebReporting,CTI Applications,SKD/API consumption,Agent Screen Pop-Up,Snap-in and ED customizations etc • Development must be familiar with SQL, Oracle, PostgreSQL, Informix/Sybase. • Development must be familiar with HTML, PHP, ASP.Net, HTML5 • Development must be familiar with CTI (Computer Telephony Integration) based application development. • Development must be familiar with .Net, Java, Linux scripting, XML/VXML/CCXML. • Development must be familiar with windows and Linux OS is must • Development must be familiar with Computer Networking. • Development must be excellent in written and oral communication skills in English Langua...

...other pages in your website, these two pages must meet the following functionality requirements: The pages must contain the 3 buttons, and the 6 search parameters shown above. Prior to clicking the Search Products button, values entered in all 6 form input fields are optional. If the product name substring is specified, the search result should only contain products whose name contains that substring (the substring match should be case-insensitive). Similarly, for the warehouse city substring, if specified. The minimum/maximum quantity & price values have a similar effect of restricting the search result, if any or all of them are specified. The Perform Another Search button should take the user back to the Product Search page. In any session, on a us...

Hello, I am looking for php code , to find total number of documents having a particular substring in whole json document. Sample json document is attached

...character_maximum_lengthelse numeric_precision end as max_length,is_nullable,column_default as default_valuefrom table_schema in ('public') --not in ('information_schema', 'pg_catalog')order by table_schema,table_name,ordinal_position) To 'C:UsersbenluteijnDownloads' With CSV DELIMITER ';' HEADER; 2) query views to csv with powershell 1 Copy (SELECT viewname, substring(replace(replace(viewname, 'obj_', ''), 'view', ''), 5, length(replace(replace(viewname, 'obj', ''), 'view', ''))), definition || 'n' || 'n'FROM pg_viewsWHERE viewname like'obj%') To 'C:UsersbenluteijnDownloads' With CSV DELIMITER ',...

...describe the steps. The steps need to be possible to implement in a MATLAB tall table so that the output is a new tall table, which can be calculated upon request. Filter the tall array to extract entries where CAN_DataFrame_ID == msg_id For the resulting filtered table, extract the data byte array in CAN_DataFrame_DataBytes and convert the 8 decimal bytes to a bit string of 64 bits Extract a substring of bits based on bit_start and bit_length inputs Conver this bitstring to decimal form Multiply the decimal value by a scale_factor and add an offset value to get the resulting phys_value The resulting phys_value should be a new tall table with timestamped physical values (which can e.g be plotted) In other words, the function to be parsed for transforming the tall array should ...

...Development with MVC framework, Open Source & PHP script customization, OS Commerce development, Custom PHP web application development, Extensive understanding of LAMP (Linux, MySQL, PHP, Apache), Open source customization expertise (Joomla, WordPress, Drupal, Magento, etc.) Benefits of PHP Solutions Low execution, maintenance and debugging costs It supports key databases such as Oracle, MySQL, Sybase, etc It is an open Source development so you can hire a developer for making web apps and websites It ensures that the architecture of the application is scalable and robust It has lots of resources for web development, such as forums, blogs and freeware scripts PHP solutions at e-Suvidha: Ecommerce, Real Estate, Store Management Solution in PHP Website Development, Shopping C...

If you are looking for an ongoing project to put your vast experience in action, we want to hear from you! It is a full time freelancing role and the client is expecting 44 hrs/week Monday- Friday in IST time zone. • Installation of Sybase software on Unix platform. • Database Lifecycle Management - Database creation, setup & decommissioning. • Database event/alert monitoring, space management, user management

Need efficient spring batch framework Java Developer with good knowledge on Oracle, Sybase,tectia client,bit bucket,git,Mockito, Unix. Needed immediately only from India. Monthly payment based on successful task completion.

we have recently migrated our SAP ECC environment from Oracle 12c to Sybase 16. This migration happened during last week.   Post migration, we are observing few performance issues with database.  

Migración de datos desde Sybase ASE v 12+ a Oracle 18c, ideal conocimiento herramienta Ispirer. Debe tener experiencia demostrable en al menos un proceso de migración de Sybase en cualquiera de sus versiones a Oracle. Migration of data from Sybase ASE v 12+ to Oracle 18c, ideal knowledge tool Ispirer. You must have demonstrable experience in at least one Sybase migration process in any of its versions to Oracle.

I have a very simple and small Visual Basic app which is used to run a query on a Sybase SQL Anywhere database via an ODBC Data Source (32 bit ). This app is not working on Windows 10 64 bit. I need someone to update the source code which I will provide so that it will work. I can also provide an installer for the SQL Anywhere Database and a sample DB

Hello ,.we need consultant for migration from Sybase to SQL server .