DSXchange

Rod, you are correct, the purpose of single_row_sc is to generate a single row. You have two choices: (a) In the zip file there are three objects beginning with the name "singlerow". By default, "singlerow_20051003.xml" is the Unix one. Within DataStage, if you delete the object ...

Probably a dopey question, given you have flagged that your server is Windows, but just in case you have flagged your DataStage Client as Windows but your DataStage server is UNIX, there is a simple solution. Alternatively, if you are using a DataStage Windows server, you could install the Microsoft...

Ahh, but my programming layout style would have laid out your "core" code like so: { gsub(/|/, "\n" $1 OFS); print $0; } for maintainability reasons. I don't know whether that makes mine 2 or 4 lines! By the way, nice implementation of a "leave this as an exercise for the re...

A much simpler awk script that that listed above would achieve what you need. Have a look at this thread . There is a reply that I contributed that is very close to what you are after. Tweak the awk script in that and you will have what you need. Suggestion: if you end up with an awk script with mor...

An awk script is one way. e.g. awk -F, ' { for ( i = 1; ( i <= NF ); i++ ) { print $0 "$" $i } }' yourfile > new file Testing the script cat | awk -F, ' { for ( i = 1; ( i <= NF ); i++ ) { print $0 "$" $i; } }' << EOD 222,333,4444 235, 5644,453 423,8576,764,353 764,431,533 EOD yi...

Satish, The solution I am suggesting is on the basis that the following understanding is correct. Namely, that you have two files: A: The "master" which represents the current state and B: The file holding records that may have potentially changed You want to take only those records in B t...

An alternative approach may be to preprocess the file using UNIX commands, deriving a commonly formatted record per line in the file. The target would be to have each row in the file with two columns; one is the "group by" and the other is the value. It will then not matter how many column...

Update to JobLogGet routine to resolved issue identified by vaby in the original code. Thank to vladimir for persevering while I found the time to correct the problem. The complete code in this post can be downloaded as part of a zip file from this web page. This may be easier than having to copy ea...

And if your flavour of unix does not have "-s" for stable sorting, you may be able to use "sort -k1,1 -u" instead. According to the man pages I have seen, this will suppress duplicates based solely on the key field. Unfortunately, the man page for sort gives no indication which o...

Belatedly throwing in an approach using UNIX ... sort -s -k1,1 yourfile | awk ' BEGIN \ { prev_key = ""; } ( $1 != prev_key ) \ { print $0; } { prev_key = $1; } ' > firstrowforkey Caveats: 1) requires your sort command to have the "-s" option 2) requires my off-the-cuff awk scrip...

If all you are looking to do is pause for 60 seconds, the after job sub-routine command simply needs to be: i.e. there is no need to write your own shell script wrapper to the sleep command. Invoke sleep directly.

David.

If you end up having to write a UNIX shell script as part of your solution, one command that you are likely to find useful is "find" ("man find" for more details). Although this can be a tricky command to master, it is very powerful. For example find /REP \( -name "*.TXT&quo...

I was trying not to presume about any flavour of UNIX tools on a Windows server since that is not necessarily a standard scenario. But suggest away I will ... There could be a fairly straight forward UNIX solution on the premise that an export from both Oracle and DB2 of the respective tables can be...

Yui,

can you just confirm for me that, as per your message description, your DataStage server is a Windows server and not a UNIX server. If it is a Windows server I don't have an alternative to offer but if it is a UNIX server, there is another option that I can suggest.

David

Indrani, My suggestion depends on which of the following you are trying to achieve: 1) Get information about a particular job. A) Try looking at the documentation on the "dsjob" command in the manuals. This command will allow you to output different flavours of information about a job and ...