DSXchange

Thank you DSguru2B.

However my Target table is a Dynamic RDBMS and so is the Error table and when I try to link these two tables it says

The Destination stage cannot support any more stream input Links

[/code]

Thanks Much.

Hello: How to implement the following in PX job. "IsNull(COL_ID) Or toTarget_Table.REJECTED" (Server job) DB2 Table -----Transformer -----Target Table | | Error Table In the PX I see link variable -->output -->Otherwise in the transformer. But I dont understand "What otherwise is supp...

DSguru2B wrote:In order to get the value of an environment variable, use GetEnvironment(%envvar%) which is present under functions->Utility.

Thank you DSguru2B.

Hello: We have defined user defined environmental variables for say $LogonID and $Password and $DBName. In the parameters of Job properties we add this environmental variable. In the Transform I use $LogonId as the value for COL_ID. When I try to compile this job get error in the Transformer. Ascent...

Same error when I use new_columnName:int32 = int32_from_string (old_columnName)

new_columnName:int32 = int32_from_string (old_columnName) Thanks DSguru2B appreciate it: However, when I use it in the modify stage, it gives the following error: main_program: Error parsing modify adapter: Error in binding: Unknown conversion: int16_from_string Expected destination field selector,...

Hello All: Want to use the Modify stage for type conversion and length conversion. 1 - Trying to convert a CHAR 5 field to a SMALLINT 5. Am able to successfully modify null values and modify the length of the field from CHAR 5 to CHAR 4. by using the following: COL_NM:String[4] =Handle_null(string_t...

Hello: Good Morning all...!!! Am getting the following error: LookUp: When checking operator: On output data set 0: When binding output schema variable "outputData": When binding output interface field "COLUMN_NM_1" to field "COLUMN_NM_1": Implicit conversion from sourc...

Hello: Source File - Sequential file Target Seq File Reject Seq file | \/ Seq file ---> Filter --> Lookup -----> Transformer_2 ----> Seq File | /\ | / \/ --/ Transformer_1 Requirement: Input Seq File has column NAME, and ID I want to look in column NAME for values "A" and "B" and...

conv_FA_001_0804_2006_4,0: Delimiter for field "AXASS" not found; input: {20 S T A M P I N G , 20 B L A N K 20 & 20 T R I M , 20 P / N 20 6 4 9 2 9 - 0 1 A , 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 2...

Hello:

I am sorry when I mentioned it was a "error". But these are just "WARNING messages" in the director.

Hello Ray: I am not getting any "errors" when I run my job. My job successfully completes. I am copying some of the lines from the director. conv_FA_001_0804_2006_4,0: Delimiter for field "AXASS" not found; input: {20 L I N E 20 I T E M 20 1 : 20 P R O D U C T I O N 20 T O O L I ...

Since the error occurs at row zero, I would hazard the guess that your "first line is column names" property is set to False when it should be set to True. The raw data string also suggests that this ... Hello Ray: I am unable to read your complete message. But.... I am pulling the data f...

Krazykoolrohit wrote:Is it possible that the warning is for seq file 0 instead of 1. You said that the column is the key.

can you view data in seq file 0 as well?

Yes I can view the data from that file too.

Krazykoolrohit wrote:Can you do a "view data" on sequential file 1? please try and do it and check if you get any warnings there.

I am able to do a view data on the source as well as the target file. The job runs successfully. But in the director I get the warning that I mentioned above.