DSXchange

yaminids,

you have unbalanced quotes in line 3 of the file or a bad quote definition. Most likely you need to change your quote character definitions in the DataStage sequential file read. If you can't find the problem, just post line 3 to this thread and someone might be able to help.

A Server restart is not always necessary, but it is the simplest method. Just remember that when killing UNIX processes never use a kill -9. If this happens to you often, please activate the deadlock daemon in DataStage and that way it will remove stale locks for you.

Sorry, because the function has varaible number of parameters you will need to specify all 3 as the "A" option is the last one.

Use: TRIM(MyString,' ','A') and it will work.

hello dhletl, normally seeing a "?" in a DataStage NLS context does not necessarily mean that the value is really a question mark; many editors and view programs are not NLS enabled and will convert UTF-8 non-latin characters to a "?" in their output. This also applies to the DS view-data windows wh...

The TRIM function has several options, in your case you would want to use the Trim (Arg1,"","A") syntax to remove all occurrences. You might want to consider using the REPLACE function as well.

Shantanu, see a bit earlier for the use of the $INCLUDE {file} {include} statement. I was surprised that you could skip the {file} part, but in the BASIC manual it states When program is specified without filename, program must be a record in the same file as the program currently containing the $IN...

David,

a "discreet connection" won't utilize a yahoo mail address.

or post this type of message in an inappropriate forum, with a misleading title.

Administrators -> PLEASE REMOVE THIS THREAD as it is duplicated in the looking for talent forum.

talk2shaanc, I'm glad you are confident that you can do it. I am not, I just wrote a test job and the COMMON is not shared between the job and it's after-job (or before-job) routine; these are different processes. So you will have to explicitly pass the values in through the after-job call or write ...

Craig,

bingo, I missed that.

You do not need to use $INCLUDE. just make sure that in both places you define the COMMON block with the same name and the same number of variables (yes, you can change the names around, common blocks are interpreted positionally). The manual might state that it makes sense to use $INCLUDE; the synt...

The COMMON block works wonderfully well when you are working within one process; but common is not shared across processes. So your method would only work if both transformers are actually in the same process. In Server this is the case, so it will work for (I just wrote a test job to make sure that...

Viswanath, I'm sorry about getting the posts and posters mixed up; I thought this was the thread where a read was slowing down and we were trying to clear that up! I would let the file fill up to maximum size, use any of the utilities available to get the optimal group counts (HASH.HELP,ANALYZE.FILE...

Viswanath, the 80-20 split and merge algorithm is usually correct; changing the point in time that a split gets done or a merge happens when large changes are happening to the file doesn't affect the actual time needed; it is best to set the minimum.modulus high so that a split doesn't need to happe...

rgandra,

the DSGetJobInfo is not an array but is a function and needs to be declared before you use it. What you need to insert into your source code is the statement



which defines that function call.

december786, if you put in one extra tier of sequence or job calls you can effect this. In your top job you just call one other inside the loop, and wait for return before processing the next record in your source file. In your second level job you call up all your detail processing jobs in sequence...