DSXchange

What do you mean by Char(7,2)? Try Char(8) or VarChar(8)

You need to take the backup before the changes are wrought. Export is the easiest means.

InputArg receives the contents of the Input Value field from wherever the subroutine was invoked. This might be a delimited string, that can be parsed within the subroutine code.

Once a project is unprotected a user in the Developer role can edit objects in that project.

Source code for ExecSH is in the Routines branch of your repository. Take a look at it. This will ease your concerns and prove what Arnd advised is correct.

<pedantry>
Character positions 122 through 125 total four characters. Therefore the second argument to substring needs to be 4.

And this will never be equal to "xyz" - a three character string can never be equal to a four character string.
</pedantry>

More information, as the technique will vary. For ease of maintenance I'd prefer not to code anything, so would prefer to use DataStage.

Create a VB script on the Windows machine to effect the conversion. Invoke this via remote execution through an Execute Command activity in a job sequence.

DataStage uses Char(128) to represent null. Windows uses Char(128) to represent the Euro symbol (which means you need to re-map DataStage's representation). Not sure why this is happening on a UNIX platform, but suspect it's related.

BCI functions mimic the ODBC API. Search the forum for SQLConnect or SQLFetch (or even BCI).

Before invoking dssh you must be attached to a DataStage project.

select the Null field value option in sequential file in format tab set it as ' ' with no. of spaces depending upon ur col width Thanks for your kind Input,but i am having this constrain for around 100 field.All fields are having different length,this means i will have to set Null Field Value at co...

Don't attempt it. Compile within DataStage.

When you compile a BuildOp with DataStage a number of other entries are created, including records in a Repository table recording the call sequence and various other stuff. This needs to happen.

Make your Char field wider than 7. The conversion function from decimal to string requires a space for the sign character. Or you could trim the result of that conversion.

The functions at the end of the Parallel Job Developers Guide are for the Transformer stage. Functions for the Modify stage are in the chapter for that stage. There are some errors; cross check with the Orchestrate Operators manual if you have a problem. For example, the Modify stage function for re...