DSXchange

Yes Andrw.I am pretty much sure that they are TAB'S.

neena wrote:I saw a note in PDF saying, If you have defined columns on the Columns tab, make sure these match the schema file. Could you please recheck this.

I have'nt defined any columns on the columns tab,just enabled RCP in the seq. file.

Hi All, I am using a schema file and RCP enabled to read the data from a sequential file. My Schema file struncture looks as follows: record {final_delim=end, delim='\t', quote=none} ( ID:nullable int32 {default='NULL'}; NAME:nullable string[]{null_field='',prefix=2}; END:nullable int32 {default='NU...

Thanks Chulett, Can you explain how the filter command in CFF stage would work. Suppose if i have a zip file called A.ZIP and it contains abc, def and lmn files. IF i want to extract only abc file, is this should be my filter command. Filter Command: Unzip a.zip abc I would like to know what should ...

Hello Every One, We developed lot of jobs which reads the mainframe files and loads them into staging area. Usually we get zipped files which will contain 10 to 12 files in it, we unzip them and read them through CFF stage and load them into staging tables. Now we are planning for production and we ...

chulett wrote:Sorry, did the 'eenie meenie' thing and decided to answer Kumar.

viewtopic.php?t=122018

Thanks Chulett.Appreciate your reply

Hello Every One,

I need to know whether datastage 7.5.2 supports oracle 11i or not. if yes, could you please let me know how to connect to 11i through datastage like any mandatory steps.

Thanks

As I noted earlier, and completely irrespective of DataStage, that leading dot your posted message showed is indeed invalid. You either need to ensure the schema is there before the dot, which makes it an 'absolute path' in a manner of speaking or you need to not have the dot. That would make it eq...

Exactly - what changed? And as Ray would note, "nothing" is not the correct answer. And if you know it wasn't the job... Chulett, When i tried to view the log file..i could not even find it in scratch and it is not even generating the log file or control file where i can dig through.I con...

It is working fine till yesterday morning.All of a sudden the jobs starts getting aborted with the error message:INVALID TABLE NAME.This is the scenario what we are doing:We are trying to append to the same table from multiple jobs and it workked till yesterday morning

'EtlErrorFileStagingOra: GenericQuery:esqlErrorHandler The error was thrown at the stage EtlErrorFileStagingOra If that is one of your source stages..then check the select query.. ".ETL_ERROR_FILE_STAGING" is indeed an invalid table name. Either ensure the owner schema is provided or get ...

I am using oracle enterprie stage with options LOAD&APPEND. If you use these options in the Oracle enterprise stage you will have to give the table name only in the property Table= And it is not possible to use query is: select * from .ETL_ERROR_FILE_STAGING and that to it is a select, not an i...

I am unable to load the data in one of my target table ETL_ERROR_STAGING.It is throwing the error 'EtlErrorFileStagingOra: GenericQuery:esqlErrorHandler Prepare failed for: query is: select * from .ETL_ERROR_FILE_STAGING sqlcode is: -903 esql complaint: ORA-00903: invalid table name, .I am using or...

I am unable to load the data in one of my target table ETL_ERROR_STAGING.It is throwing the error 'EtlErrorFileStagingOra: GenericQuery:esqlErrorHandler Prepare failed for: query is: select * from .ETL_ERROR_FILE_STAGING sqlcode is: -903 esql complaint: ORA-00903: invalid table name, .I am using ora...

This might with the columns with the same name in both master link and reference link which are not used as a key.Try by removing un-used column with the same name in the reference link.Hope this should work