Automic Workload Automation

  • Private Community
 View Only

  • 1.  SQL job Column separator needs to set a TAB

    Posted Apr 29, 2021 06:48 AM
    Hi All,

    We have a requirement of SQL job needs to extract the data from database. In the SQL form >>>Result Table settings>>>Column separator as <TAB>. But we are unable to set this in Column separator as <TAB>.  Please suggest is there any way to set up the Column separator as "TAB" in SQLjobs.

    Regards,
    Srinivas.


  • 2.  RE: SQL job Column separator needs to set a TAB

    Posted Apr 29, 2021 10:26 AM
    Edited by david john May 04, 2021 03:33 PM
    You can try w3 school for this. That may help you. What is your data about is it about organization or read light novels ? I mean is it critical.
    Original Message:
    Sent: 04-28-2021 02:44 PM
    From: Srinivas Reddy
    Subject: SQL job Column separator needs to set a TAB

    Hi All,

    We have a requirement of SQL job needs to extract the data from database. In the SQL form >>>Result Table settings>>>Column separator as <TAB>. But we are unable to set this in Column separator as <TAB>.  Please suggest is there any way to set up the Column separator as "TAB" in SQLjobs.

    Regards,
    Srinivas.


  • 3.  RE: SQL job Column separator needs to set a TAB

    Posted Apr 30, 2021 01:14 PM
    Hi John,

    Thanks for suggestion.
    I have tried this way . notepad++ just hitting the tab key and copying that blank space and pasting that as the separator. But after saving and executing the SQL job. it is converting to semicolon(;) . Result is coming with semicolon delimiter.
    If any workaround or any method is possible to achieve my requirement.

    Thanks in Advance.
    Regards,
    Srinivas.




    Original Message


  • 4.  RE: SQL job Column separator needs to set a TAB

    Posted Apr 30, 2021 05:05 PM

    How about write the results to a file with ";" data delimiters, and then run another process to convert ";" to tab?

    I have never used tab characters within this product.



    ------------------------------
    Pete Wirfs
    SAIF Corporation
    Salem Oregon USA
    ------------------------------

    Original Message


  • 5.  RE: SQL job Column separator needs to set a TAB

    Posted May 07, 2021 01:40 AM
    Hi Pete,

    Thanks for the update. I have ran the another process to convert semicolon to Tab.

    Regards,
    Srinivas.
    Original Message


  • 6.  RE: SQL job Column separator needs to set a TAB

    Posted Jun 06, 2021 10:15 PM
    Hi Srinivas,

    I am facing the same problem now. Do you mind sharing what process did you use to convert to Tab?

    Thanks,
    Melbert
    Original Message


  • 7.  RE: SQL job Column separator needs to set a TAB

    Posted Jun 07, 2021 10:06 AM
    Hi Melbert,

    I have used another Linux job as a successor to SQL jobs and the below cat command to replace "~" to tab delimiter in the SQL data.
    "~" is column seperator in our SQL jobs.
    ! Below code is to replace ~ with TAB delimeter
    cd /xx/xxxx/xxxxx/xxxx/orclrac/temp/
    !pwd
    cat &SOURCERESULTFILE1#
    cat &SOURCERESULTFILE2#
    cat &SOURCERESULTFILE1# | tr '[~]' '[\t]' > TEMP_&SOURCERESULTFILE1#
    cat &SOURCERESULTFILE2# | tr '[~]' '[\t]' > TEMP_&SOURCERESULTFILE2#

    ! Below code is rename temp file to required .required file name.
    :WAIT 30

    mv TEMP_&SOURCERESULTFILE1#  &RESULTSFILE1#
    mv TEMP_&SOURCERESULTFILE2# &RESULTSFILE2#

    Regards,
    Srinivas.
    Original Message