DSXchange

Yes, you can use the ereplace() function to convert "'" to "\'", i.e. EREPLACE({string},"'","\'") ... Thanks ArndW, you're a lifesaver :) Solution: Removed the sed which was piped along with the cat and used the CommandOutput from the Execute Command and used...

I think you will need to escape even the = character. I had a problem with that once. it is considered as a delimiter or something and it would stop at the = character. Thanks for the reply Maveric, but looks like the = character needn't be quoted. Earlier SQLs with = have been executed successfull...

Is there anything similar in the places where the parsing stops? As Stefan noted, it might be special characters. ... ArndW as you suggested, I ran the shell script that parses the file and the output from the shell script at the Unix command prompt is cut short and not at DataStage level. The code...

Is there anything similar in the places where the parsing stops? As Stefan noted, it might be special characters. ... ArndW as you suggested, I ran the shell script that parses the file and the output from the shell script at the Unix command prompt is cut short and not at DataStage level. The code...

It could be that you need to "escape" special characters before passing them to a job as parameters. Example select col1, col2, col3 from a.table where datcol = '2008-02-18' needs to become select col1, col2, col3 from a.table where datcol = \'2008-02-18\' Thanks for the reply frost. Yes,...

The 1169 looks very much like the limit from your command line, not from DataStage. Try using Google to search for "{your UNIX} maximum command line" to get additional information. ... I tried the search but I didnt find any results that could help me. The funny part is, i am passing two ...

Hi, I have a sequence design which uses an Execute Command Activity stage which 'cat's an SQL file and passes the CommandOutput as a value to a parameter in a job. The problem is that the whole SQL is not being passed to the Parameter. The total number of characters in the SQL file is 1169. I have b...

All, Input: Table A - Primary link A.key1 Table B - Reference link B.key1 Output: 3 Output Files - Get all the records which are in both the tables(A.key1=B.key1) - Records which are there only in table A - Records which are there only in table B Is the above output possiable using single look up s...

When the lookup fails, the reference input columns are all set to NULL by the Transformer stage, which invalidates the use of "=" and "<>" operators. You can test the link variable NOTFOUND f ... But if the nullity of the columns from the reference link is set to 'Not Null' , th...

select 'What do you mean?' from dual where stage_name in ('FUNNEL','AGGREGATOR','MERGE','PIVOT') Sorry, but that's all that came to mind when I saw your post. Perhaps someone else has something more constructive, but I honestly have no idea what you are trying to find out here. There are no 'sql qu...

I have one query regarding Lookup Stage. In the previous post of this forum some body had mentioned the lookup as in-memory lookups . So I want to know, how many types of lookup present in Lookup Stage , and how do they differe in implemention, in result as well as in performance too. Thanks & ...

I'd been advised not to use a column generator because 'if its in the "Development/Debug" section of the palette its only to be used in Development or debugging - and not in live jobs." What's your opinion, is there anything wrong with using "Development/Debug" stages in li...

4friends wrote:please explain me about these

1.scratch diskspace

2.conductor

3.section leader

4.players

5.score

You could try the following:

For:-

1. Manuals that come along with installation
2-5. Search the forum

this is the example My source is DB2 No Name Bank Flag Eff_date End date 1 aaa city Y 2007-11-22 9999-12-31 1 aaa hdfc N 2007-11-19 9999-12-31 1 aaa icici N 2007-11-18 9999-12-31 Based on this I want to derive END_DATE based on the effective date of the prevous records when ever the sourgate key co...

Hi I hava a two seq files file1 ENO,ENAME 101,ABC 102,BBB 103,DDD FILE2 SAL,AGE 50000,45 7000,66 8000,77 I sove this problem using this seqfile1----->surrogatekey--- merge---->seqfile seqfile2--> surrogate key------ my problem is i want to target out like this, any posibility out put ENO ENAME SAL ...