DSXchange

We are setting up a new staging enviroment at our production site. When we export the jobs from production into the new Staging instance we ger the following error: Error : Could not locate operator definition, wrapper, or Unix command for "sqlsrvrread" Operator sqlsrvrread does not exist ...

greetings rjdickson, Thanks for the reply! If you add another J to the list it will still give you Frank instead of J because its now the highest frequency. Since both Freq and Lenght would always get a hit, it will never use the previous rules best record if there is a tie condition in the last rul...

Greetings dsxChange I'm surviving an Individuals First, Middle and Last Names. I have to use the following pecking order to break a tie. 1) Name Part with the greatest Frequency (Use next rule if a tie) 2) Longest text (Use next rule if a tie) 3) alhabetical Order (I told our customer this is not a ...

Are you sure there is an intersection between the data results between TableA_ColB and TableA_ColC? Could you please post the actual rule logic. Are any of the fields nullable?

Is there a easy way to delete all of the validate rule results. I have been going to view output and maunally deleting the rows. We now have over 500 validation rules and its extremly time consuming to do this. I do use iajobs to execute all of the rules from a batch file. I was hoping there was a e...

I'm trying to pass the following header to a web service. I'm using the Web Service Transformer stage to call the service. '<soapenv:Header><urn:SecuritySoapHeader AppUserFmid="0x010002E000000BE7"/> </soapenv:Header>' I put the following header message in a VarBinary field like the manual ...

Where do you configure the location and size of your scratch space. My C drive is running out of space and I want to move it to our disk array which has 3 TB.

Derrick

I have a date in the format of yymm, It there anyway of getting the StringToTimestamp function to default the century properly. When you don't specify the century, it always uses 19. If the year part is greater than 50 I would want it to use 19. Otherwise it should use 20. StringToTimestamp(DSLink4....

Greetings Ray, Now that I got the nulls handled and I can append a time of 00:00:00 to the date that is coming in, but how do I validate that the date is correct before I attempt to translate it using StringToTimeStamp? The IsValid command does not allow me to specify a format. Thanks in advance Der...

Greetings DataStage Guru's I'm new to datastage and I have what I know is a easy request. All I want to do is translate a Date that is in a String field in the format of yyyymmdd to a timestamp using the regular transformer. I was trying to use the IsValid function to first make sure it's a valid Da...