DSXchange

Thanks, This message board used to be free...?? Only this one time, actually for less than 14 cents a day you can become a premium member and get access to the ocean of knowledge. Highly advisable. The definition of a passive stage for your purposes is one that reads from a source or writes to a tar...

I cannot read AarndW's messgae as I am a standard member...can you tell me what he said.

All I want to know the fundamental differcence between active and passive stage.

DSguru2B wrote:Check out ArndW's reply in the following post
viewtopic.php?t=97052

Thanks...

kumar_s wrote:Still you have the option to edit dsx (may be not advisable by everyone )

-Kumar

Hmm...and how do we remove it from dsx...

Hi, How about, if your mannually take off the unicode option for varchar field. You can also try to remove from dsx as a whole if the above doesnt works. Out of curiosity, what makes your job to break if unicode present? -Kumar Kumar, We since I am using Run Time Column propogation and not manually...

Hi You can disable this by using Datastage Administrator. Logon to the project where you want to disable. Inside that untick the Enable Runtime Column Propagation for Parallel Jobs Regards Hi I think I was not that clear. What I ment is that in my Job design I want run time column propogation. Howe...

In my Job design I am using run time column propogation. The job design is simple...But it uses "Run Time Column Propogation" Job design : Table_A ---> Transformer ----> Table_B The metadata of the tables A and B are DLV_DT VARCHAR2(8 BYTE), FRQ VARCHAR2(3 BYTE), PCS_DT VARCHAR2(8 BYTE), M...

Your image quota has been exceeded and you still haven't found out what schema values DS is using. Someone more knowledgeable than I will certainly help you. It might still behoove you to find your orchadmin command - if not for this issue then for the future. I think I got it running... it was an ...

Can you paste the snapshot of the column definition as defined in your oracle stage Arvind, I look through your suggestion.. and it seems that the medata matches and the Nullabe are set to YES Attached is the ling to the image of my job http://us.share.geocities.com/kapil_ladha/meta.bmp ( If the im...

Kapil - I give up. We are not trying to hide a solution from you and you don't need to restate your query. If someone could answer your question with the data listed so far they would have. You are getting a schema error. You need to list the schema the way DataStage sees it. Orchadmin will do that...

I'm not at a DataStage connection now, so I can't give you the exact path. It seems that "orchadmin" is not in your UNIX session's path. You will need to add it or execute the program from it's location. It should be in a bin directory underneath your $ORCHHOME directory; but you can alwa...

That is very legible, try doing a UNIX "orchadmin describe {AbsoluteDataSetFileName}, that is easier to cut-and-paste as text here. what the Unix command? I tried... $ orchadmin describe ladha.txt and get the message ksh: orchadmin: not found. Vi editor to view the file is also not that helpfu...

Hi, What is the stage you use in the job for input. Are you doing any type conversion. Using any transformer? Is there any field length been unhaldled or empty? Have you given any varchar or char type of field as feild length as 0? What type of data is it? -Kumar Hi Kumar, I am doing a simple movin...

hi guys, when i run a px job the job abborts with the following message : - main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Parsing parameters "max=0" for schema type "ustring": Max length must be positive, got: "0" Could not fin...

Kumar As I mentioned, If I hard code the "key" value in when I select explicit key and values then the Change Apply works. However, on setting the option of "All Keys, Explict Values", I get the "Fatal" error : main_program: Added Field has duplicate indentifier(): CHAN...