DSXchange

I had a posted the same query earlier ... Maybe u should check out this link

viewtopic.php?t=106418&highlight=diff%2A+levels

I decided to go for the Oracle method .. used the LEVEL pseudocolumn, connect by, etc etc...

Congratulations kumar! ... keep it coming ...

Hmmm .. that wont work with the environment I've been setup in :( So, how does the DataStage Manager import metadata without a client connection? ODBC? I'm pretty sure you have sqlplus on your DataStage server (at least the node that has the DS Engine.) You need to check this as your method is not ...

It should work. Does your sql run as expected from sqlplus or your favourite sql tool? ... Yes it does ... Its running perfectly fine on my Oracle 9i install ... The job design : Row Generator -> Oracle Enterprise Stage (with Write method = Upsert and a User Generated SQL query) The SQL query looks...

Command line execute sqlplus and run your query that way? Seems awfully weird to invoke sqlldr just to run a query. Hmmm .. that wont work with the environment I've been setup in :( Wont a merge sql query work if i set the write mode to upsert and give The query as a user generated one ? Its basica...

Hi, I have a job design which looks like this :- Row Generator Stage -> Oracle Enterprise Stage The row generator stage is just a dummy stage to enable the Oracle Enterprise stage to run a complex merge sql query which updates a table. When I run, the job I get this error : OraADSTEST_TABLE,0: The c...

There are 2000+ source sequential files each of around 600 KB. We are reading these files in a transformer, splitting and joining it using a merge stage. When we run the job, The Merge stage is failing with an error: 'Operator terminated abnormally,Received signal SIGBUS' How can we utilize the merg...

When I give a blank filename or blank folder name, it got aborted. But interestingly with different error message Sequential_File_0,0: Source subproc: awk: Input line cannot be longer than 3,000 bytes. The input line number is 4. The file is /. The source line number is 1. What is your server flavo...

My Bad!!! Its "File=?" and not File Name. I gave File = /dev/null and Filter = awk -F'\t' '{if( FILENAME != " #FileDirectory#/ " ) {print $0} else {exit 1}}' #FileDirectory#/#Filename# And when I give a file name which doesn't available, it gave out the error Sequential_File_0,0...

I think it must be the FILENAME != "#FileDirectory#/". Ever. How come? Did you try to hard code the condition (ex. && 1 != 2 ) to exercise the else {exit 1} in order to see if the overall flow will work? When I tested it I deleted the value of the file parameter. I didn't blank it...

What is the exact issue now? As trobinson and I mentioned, it gave out error when there is no file. You might have entered the awk command in option provided for "Filter". What did you mentioned under the option provided for "File name"? Thanks for the quick reply kumar... Yeah ...

Sorry for bumping this old topic back up .. But, after a week, I still have not found a solution to the problem ... :cry: Kumar, did you mean we have to check for FILENAME = "/dev/null" in the initial If condition? I've still not found a solution to this problem.. Is there anyway we can le...

Under the General Tab, you might use Filter command to this, are you using /dev/null in "File Name" option? ... Hi kumar, yes i am placing the following as the filter in the stage: awk -F'\t' '{if( FILENAME != " #FileDirectory#/ " ) {print $0} else {exit 1}}' #FileDirectory#/#Fi...

What is the value that you have given in "Filename" option? The given option works. If I dont pass any value to parameter it gives out "DSD.SEQOpen GCI $DS.SEQOPEN error 11.|" from datastage. You mean the #Filename# parameter? ... Well for successfull run i just type in the File...

/ at the path isn't necessarily giving a problem. Since a backslash is present in File path, it need to be quoted. awk -F"," '{if( FILENAME != /dir1/dir/) ..... giving out the error that you have reported, where as awk -F"," '{if( FILENAME != "/dir1/dir") ..... is not....