DSXchange

When i tried in parallel job i used Transform type.

When tried in server job i used T/F stage as input and ODBC stage as output stage and there i choose the option stored procedure and gave the exec command in the Enter SQL tab.

HI I have one migration project from 8.1 version to 8.5 Version. In that project one to the job is used to trigger Sp from SQL Server 2005. It was woring fine in the 8.1 version and DB as well. The purpose of the SP is to populate the staging area data to target tables. The target tables are having ...

IN windows in saved the file with .vbs extension and ran the file from comand prompt. i..e, just gave the file name. It ran fine and got the output. If i did the same thing in datastage it is going into the continuous running mode and if i give the command as cscript "Path of the file to be exe...

Hi All,

I have one VB Script to be executed.Could any body please suggest me how to execute it from datastage.I heard that it is possible to run from execute command activity.If so Please let me know the syntax how to call the script.

Thanks & Regards.
Bhanu.

Hi All, My requirement is to insert the data in to the table at the same time i have to pass the total number of records processed through the link as a paramater to a stored procedure. for That i had seqfle-->T/F-->ODBC Agian from the same T/F i took an aggregator stage and stored procedure stage. ...

My job is like sequential file -->sort-->filter--> T/F-->-->sort--> sequential file. I am getting the problem i the T/F stage.The column1 is comming form the i/p sequential file in which the column has nullable NO as while creating the i/p file itself NULL values has handled. still i am getting the ...

Hi My Requirement is to remove the special characters and check if any alphabets are there and any numbers are there in a column. i have used the following logic If Alpha(Convert("~!@#$%^&*()_-+=|\}]{['':;?/>.<,`", "", Column1)) Or Num(Convert("~!@#$%^&*()_-+=|\}]{['...

Hi all, My Job is having ODBC stage --> and T/F stage--> sequential stage. I have to handle the null values if it comes from database to either empty or to a value. I handled them using IsNull(i/pcolumn) in T/F stage. but in output those values are not reflecting and are dropped with a warning messa...

Instead of using StageVar : Index(Word1,'-',1) can you try with this
StageVar : Index(to_processing.pri_emp_add1,'-',1)

using the above one solved my issue.

Thank you for your help PAUL:)

Thank You so much Vinoth.

Its working fine now.

Hi IF the input column contains two words i have to take first word in to one variable and second in to another and again in the first word i have to check for the hyphen(-) and if it is there i have to take the part before the (-) in one variable and part after the (-) in another variable. thats wh...

Thank you Paul for correcting my logic but still i am facing the same problem my first record is giving as

SAME-AS
and remaining all are giving as this

SAME
SAME
SAME
SAME

Please note : (execution mode is sequential in T/F stage)

Now when changed the execution mode to sequential in transformer i am getting the o/p for all records except for the first record, still a blank space iam getting for that

Could any body please help me in solving this......

Thanks in advance for your help.

My requirement is to seperate the word in to 2 parts if it contains '-' based on this first part should contain the part before '-' and second should contain after the '-'. for that i used the following in t/f stage I have taken the stage variables: StageVar : Index(Word1,'-',1) StageVar1 : Index(to...

Hi, My job is having ODBC stage--->t/f-->sequential file stage. I am not able to get properdata to the output. I have used stage variables in the transformer and built logic according to the requirements.I am getting the proper output but for half of the rows only remaining half are blank. I was get...