DSXchange

Field(InLink.TheString, "-", 1, 1) ... hi am having policy_no a a column. In this column only am havin hyphens. could u pls explain in detail how to implement it.. Thanks in advance....... hi will this logic work if the policy_no not havin hypthen in it. because am having that also. Thank...

hi, i got to load the data into Database and if the data get changed (in future) means am not supposed to overwrite it.My primary key is Customer_ID.I mean am in need of to maintain the history in the same file with cust _id as a primary key as aforementioned.Will surrogate key logic be better or no...

ray.wurlod wrote:

Code: Select all

Field(InLink.policy_no, "-", 1, 1)

...

hi,
could u pls explain how it will work?i mean can u gimme the logic behind it..

Thanks in advance.....

ray.wurlod wrote:

Code: Select all

Field(InLink.TheString, "-", 1, 1)

...

hi am having policy_no a a column. In this column only am havin hyphens. could u pls explain in detail how to implement it..

Thanks in advance.......

hi all, one of my column values containin hyphen(-) in it. for ex the input seems like 1200-12,563467-093,3789652-02. In this scenario am in need of the value before the hyphen only and meanwhile the number of digits before the hyphen will greatly vary.Can any one help me to how to get the required ...

hi all, one of my column values containin hyphen(-) in it. for ex the input seems like 1200-12,563467-093,3789652-02. In this scenario am in need of the value before the hyphen only and meanwhile the number of digits before the hyphen will greatly vary.Can any one help me to how to get the required ...

ArndW wrote:I'm not quite sure what the direction of the question is.

You can start any DataStage job from any sequence use the Job Activity Stage, and you can also start any DataStage job from another job us ...

Could u pls explain how to start any DS job from another job?

Did X3 actually start and then abort, or did X3 not start at all? Look in the log of X3 to find out. ... Hi Ray, X3 did not start at all... And also..as I mentioned ..it is X2 that failed with the message Job is not int he right state(Compiled and not running)..I had cleared the status of this job ...

Hi all, I have a problem. I must get the number of rows which are really updated and inserted in database by a job. I haven't a way to identify which rows are updated (I haven't a date for this in example.) I must then insert this number in the database. Have you any idea to solve my problem? Thank...

Actually it wont give it in sorted order.It ll be workin based on the key n if u particularly wan in sorted order den u shud use sort stage.

Thanks,
veera

Actually i got to generate sequence ID'S.After that, i'll load d data into DB.So i ll generate the ID'S irrespective of the rejection.So i need to pull the ID'S again without generating again cos am supposed to maintain uniqueness.Is there any logic for single rejection run?and moreover am supposed ...

hi frnds, actually am supposed to load 11 tables into SYBASE sequentially.am expecting tat data ll be rejected by database in abnormal condition i mean some data mismatch n all and more over i got to run the job again with cleansed rejected data.So do help me to resolve it.Give me the rejection logi...