DSXchange

chulett wrote:Kindly explain what you mean by 'special' characters. ...

They look like this

ZI I cS
ZI I S
ZI I cS
ZI I /S
ZI #I cS

I have a character 8 field, which has special characters at mainframe source, but when these values are being loaded to the db2 tables, the special characters are truncated even though i am not using any trim functions.

Kindly update me on the issue

Are you looking at the correct log? ... Ya, its the correct log i am referring to., Compared with an earlier day's log., the current day's log is missing the following entries, Environment variable settings, Prarallel job initiated. Current day's log has only the following entries, Starting Job ......

What do you mean by "no data being processed" - that the jobs run but don't do anything or that the log files contain no entries? (or both)? I recall having seen a similar problem that ended up being ... No data has been extracted, but the log for an earlier day has all the entry for Envi...

The Director shows the job executed successfully, but there is no data being processed, even the Environment Variable Settings is not seen in the log.

What could be the issue,

Hi all, i need to perform a lookup with fields TABLE1.EMPLID CHAR(10) and TABLE2.EMPLID CHAR(11). which are data sources from DB2. Both the fields have only numeric values. I tried to typecast the two fields as INTEGER and equate them in the lookup stage, but the lookup fails. Is there any other alt...

chulett wrote:

ds_raman wrote:Thanks but i need to route the recors to Error Link, so i have to make use of StageVariables

No, you don't have to use stage variables. You can use your null check directly in the constraint that 'routes' the records.

Solved the problem.,
Thank You,

chulett wrote:

ds_raman wrote:Thanks but i need to route the recors to Error Link, so i have to make use of StageVariables

No, you don't have to use stage variables. You can use your null check directly in the constraint that 'routes' the records.

Solved the problem.,
Thank You,

What is the Data type of your input and output fields? And Why use stage variables? A simple derivation like If IsNull(In.EmpID) Then "N" Else In.EmpID would do. This will work only if the data type is char or Varchar. Only then would you be able to substitute the value N. Thanks but i ne...

balajisr wrote:Can you post your derviation?

Stage Variable i am using Null_F=NullToValue(EmpIdExist,'N')

And on the Constraint if Null_F='N' then the records are routed to Error Link

Maveric wrote:Check the nullability of your target fields. Post the derivations here. Are you trying to substitute N for a NULL, or are you just checking for null and populating the Flag field to N?

I am trying to substitue "N" for nulls

Hi There are null values coming in from source and i need to set a flag for this field(Empid), but when i try to check if Empid is null in Stage variable, the records get dropped, and the same applies for date of birth field, DOB, Is there anyother way in Transformer by making use of Stage Variables...

HI ,



we are not able to run our job bcoz of below error

SHARED_CONTAINER.LKUP_KEY_SEQ,3: The runLocally() of the operator failed.

Thanks in advance

ray.wurlod wrote:Then what you now need to do is post the syntax that does work, and mark the thread as Resolved.

Thank you all for the Help


OsCmd8 = 'cat ':strFileName1:'>> ':strFileName:''
Call DSExecute(OsType, OsCmd8, OsOutput8, OsStatus)

This syntax worked fine

Thanks, But i need to do this in After job Routine, If the above command suffices, then go to the job properties and in the After SubRoutine, choose ExecSH. In the input value field, place the command. You are good to go. Thank you Very much With OpenSeq and ReadSeq i could only assign the first li...