DSXchange

I don't have access to a DataStage that I can use to test at the moment, but believe that you can add more AND conditions in the range lookup expression editor grid. Will have to put this on hold till I can test - maybe next week.

Create the following stage variables. svSRLF <-- Char(13) : Char(10) svFirst5 <-- Field(InLink.TheString, "|", 1, 5) svCol6 <-- Field(InLink.TheString, "|", 6, 1) Write the following single-column row into a Sequential File stage with 000 as the quote character and DOS style line...

That behaviour is also driven by whether you have a default value defined for the particular field.

There are a few, such as DateFromDaysSince(), PrevWeekdayFromDateSince() and so on. Do some research to find out precisely the one that best fits your particular requirement. They're in an appendix of the Parallel Job Developer's Guide.

Your question embodies the solution. On the reference input link in the Lookup stage choose Range as the lookup type then double click on the value cell to open the range specification editor. Can you not simply continue to edit the expression in the range lookup expression editor? Add another AND a...

Is the manual for the DB2 Connector available in PDF format?

1. Nothing of which I'm aware. Does context-sensitive help provide any clue?

Depends on the data type of link.col1

1. No. APT_CONFIG_FILE is job-wide.
2. No. You could use multiple schema files and parameterize the schema file name property.

No, but you could use a Lookup.

DSXRAG wrote:I am unable to see your full reply as it is a premium content.

That is because you don't have a premium membership, a situation that is easily remedied.

I want the first original password to be converted into encrypted and then use this encrypted as a password for the jobs for connecting to database by assigning to a parameter. does this work If I use convert()? Yes, but you can not provide already encrypted parameter values to a job - it must be d...

What are the data types of the two columns?

Topic relocated per request - Andy

Assuming that you mean a Connector, then the easy approach is to associate a Parameter Set with the Connector, and provide parameter values at the different times.

Then a simple Convert() function will do it for you if you are happy with character-by-character substitution. If you want each character replaced by two or three (or more) characters you will need to create a routine, but it's not a difficult one to write. For example, if your domain of password ch...