Skip to Content
24x7 Support
Email: mail@example.com
Call Us +(21) 1234 5678

    • Home
    • MSSQL
      • SQL On Linux
      • T-SQL Scripts
    • Sybase ASE
      • Sybase Scripts
    • Sybase Replication
    • Sybase IQ
    • Linux
    • Search for:

    1. Home
    1 Aug, 2020
    Using multiple variables from a file and loop in shell scripts 0 (0)
    Linux

    There are several ways to read a file in loop, here are few of them with examples

    consider my input file is as below

    FileName: file1

    File Content:

    A B C
    D E F
    G H I
    J … Read the rest

    1 Aug, 2020
    How to replace all white space with comma in a text file 0 (0)
    Linux

    for example, i have a text file like below

    test1 test2
    test3 test4
    test5 test6

    i want my text file to look like as below

    test1,test2
    test3,test4
    test5,test6

    use below sed function to achieve the result.

    sed -e 's/\s+/,/g' old … Read the rest

    1 Aug, 2020
    How to remove spaces between lines from a file 0 (0)
    Linux

    for example, i have a file like below

    test1 test2

    test3 test4

    test5 test6

    i want my output to look like as below

    test1 test2
    test3 test4
    test5 test6

    use below sed function to achieve the result.

    sed '/^ *$/d'

    … Read the rest
    1 Aug, 2020
    Splitting one file into multiple and running them in parallel. 0 (0)
    Linux

    Syntax:

    split -d -l <no. of lines> <input file> <prefix name>

    Example:

    split -d -l 3 testsplit.txt testsplit.txt.

    here, '-d' option will split files with numeric suffix like x00, x01, … x0n

    here, '-l' is used to split a file … Read the rest

    30 Jul, 2020
    Sybase Replication Thread down issue:Foreign key constraint violation occurred 0 (0)
    Sybase Replication #foreign key constraint, #sybase replication

    Error Code Description: Message: 546, State 1, Severity 16 — 'Foreign key constraint violation occurred, dbname = 'db2', table name = 'table1', constraint name = 'constraint1'

    Cause:This issue occurs when data inserted into a foreign key does not … Read the rest

    30 Jul, 2020
    Sybase Replication Thread down issue: Trigger Disabled 0 (0)
    Sybase Replication Sybase, trigger

    Error Code Description: Message: 4986, State 1, Severity 10 — 'Warning: trigger 'TestTrigger' is already disabled.

    Cause: This issue occurs when someone tries to disable a trigger on production database table and then warm standby replication tries to … Read the rest

    30 Jul, 2020
    How to check if windows machine is physical or Virtual 0 (0)
    MSSQL

    Method 1:


    For windows, Click Start → Run → open cmd prompt →  run below command

    systeminfo /s %computername% | findstr /c:"Model:" /c:"Host Name" /c:"OS Name"

    Method 2:

    Click Start → Run → open cmd prompt →  run below command

     msinfo32

    Here, System … Read the rest

    30 Jul, 2020
    What is latency in Sybase database: 0 (0)
    Sybase Replication Sybase Latency

    Latency is the time it takes for the data to replicate at the subscriber once it updates the primary.

    Reason for latency

    1. When DSI thread is down
    2. When huge batch jobs running on the primary database.
    3. When blocking at replicate
    … Read the rest
    29 Jul, 2020
    Bypass recovery for Sybase ASE database 0 (0)
    Sybase ASE Sybase bypass recovery
    Case description : Bypass recovery for Sybase ASE server database.
    Cause :Database recovery failed during Sybase ASE reboot due to log full issue.
    Solution:- Perform Bypass Recovery as shown below.
    1.      Steps to perform before shutting down


    Login to the
    … Read the rest

    Posts pagination

    1 … 13 14
    Recent Posts
    • SQL Server: T-SQL Script to find object level permission of specific table
    • SQL Server: T-SQL Script to find object level permission of user database
    • T-SQL Script to get user with DB OWNER role in SQL Server
    • T-SQL script to list all database user access in SQL Server
    • T-SQL script to find active processes in SQL Server

    Pages

    • About Me
    • Contact
    • Disclaimer
    • Privacy Policy

    Categories

    • Linux (8)
    • MSSQL (75)
      • SQL On Linux (15)
      • T-SQL Scripts (19)
    • Sybase ASE (26)
      • Sybase Scripts (1)
    • Sybase IQ (3)
    • Sybase Replication (27)
    • Uncategorized (1)

    Archives

    Copyright © 2025 | Powered by Neom