DSXchange

Craig is right there. Your solution is a good workaround, but it is always wise to understand how a problem can be best solved, and not just solved for the sake of solving it.

Hi. My mistake I didn't go though the actual metadata information. The transformer is your ONLY option at this juncture. The Convert function should be helpful Convert - Converts specified characters in a string to designated replacement characters - parameters: fromlist (string) tolist (string) exp...

Hi.

Sorry but changing the target SQL type to Varchar doesn't help. The database still puts the block character.
One more thing, the database insertion is highly inconsistent, as in some fields are affected by this, while some aren't.

Could you tell me why this may be so?

No, I don't. Would that impact anything as such?

While you could always use the Transformer stage to remove the "" characters, in the Sequential File stage itself, there is an option that specifies that variable length fields are enclosed in single quotes, double quotes, or another character or pair of characters. Of course in this case,...

I am applying an environment variable for padding the blank characters in a Char field. The variable is set to value "0x20", which corresponds to " " in ASCII. However, when the data is written to the database, the blank characters are padded not with the " " character,...

Hi.

I have cleared the Upstream partitioning, as mentioned in my query. As regards the main input, is there a specific protocol to be followed while setting the partitioning for input links when using Lookup Stage? As in Entire for reference and (say) Hash for input?

Hi. I have this job wherein I am using the Lookup stage with reference links as DB2 API stages and my main input is from a dataset. I am clearing the partitioning in the DB2 API stages, and am applying Hash partitioning as also sorting on the lookup key for each. For the main input, I am setting par...

I will try to get that done, but till such time, any suggestions on how I can achieve what I need to do?

Hi.

I am not looking at Environment Variables per se, as they would require some sort of default value et al either at the Job level or the project level.

Is there some way of either creating a DSMacro or a DSRoutine to achieve the same, and to retrieve the value at runtime?

Hi.

Sorry, but I can't read the premium content part.

Is there some way you could explain it to me without that part disappearing behind the premium content curtain?

Hi.

Am scheduling through Datastage. How do I achieve this in this case?

Hi.

I was unable to find any environmental variables named like what you had mentioned. Any other suggestions?

Hi.

Could anyone of you tell me how I can get the value of the userid that I use to log into Datastage Designer as a parameter to be used in processing?

I was advised to do this when I had a similar problem with Join Stage. At that time, I understood the rationale for doing so as that when I clear the partitioning before sorting the data, I am sending the data to be sorted as a single block, and not as disjoint block. After sorting, when the dataset...