DSXchange

Thanks Ray for the query It explains me well.Now I am able to update the sequence. I have one more question SELECT @ID FMT '32L', F1 FMT '10R' FROM SDKSequences USING DICT VOC; VOC ------------------------------------------------F1 ------------ HCM 3 EPM 12 numbers under F1 field are no of records, ...

Craig,

The way you suggested to get the table names worked fine .Thanks

Hi, We are testing peoplesoft delivered job.In one of them there is a function KeyMgtGetNextValueConcurrent to generate sequence number. when I ran the job, it created seq numbers from 1 to 10.now I want to reset this number back to 1 I gave this query in adminstrator UPDATE SDKSequences USING DICT ...

Thanks Craig.You mean ,do I need to run all 100 dsxs using the custom job

HI, I have 100 jobs in one project.We used one table as source in many jobs.I wanted to find all jobs ,thatt used the particular table as source. We don't have any table definitions, so I saved table definition in repository under Saved category.I did usage analysis on this table definition,but it w...

Thanks MATT and DSGuru for your suggestions. let me take a look and get the clear picture of the code you send. Just now I put these 2 derivations in stage variables.I checked for few records , It looks fine.but I am not sure this derivation works if I get different data formats in future. if alpha(...

I forgot to mention in my previous mail,few records have just type , no year mentioned. like MAT NAT no year mentioned here when I use LEFT(LkInXfm.SOLDYEAR, LEN(LkInXfm.DEGRYEAR)-2) right(LkInXfm.SOLDYEAR,2) when I use these functions , it is splitting previus record like M AT can you please sugges...

Thanks for your reply DSGuru

Data looks exactly like this

CAR 3 (3 spaces between 2 fileds)
CAR 50 (4 spaces between 2 fileds)
MD - 71(No space) ' here I need to put 'MD -' in one filed and 71 in another filed
ASSO 82(No Space)
3 YE 95(No space)

Thanks

HI, one of columns values from seq file look like this SolditemYear CAR 3 (3 spaces between 2 fileds) CAR 50 (4 spaces between 2 fileds) MD - 71(No space) ASSO 82(No Space) 3 YE 95(No space) I need to split the item and year into 2 separate fields I used 2 stage variables FIELD(LkInXfm.SOLDITEMYEAR,...

something goofy happened, when I moved file from windows to Unix.
I copied the file again to unix ,now it is showing 4 digits

changed to varchar, still it is showing 2 digits

sorry, submitted 2 times

sorry, submitted 2 times

HI thanks for all of your inputs and suggestions I stick with this derivation Iconv(DSLink71.HIRED, "DMDY[2,2,4]") I have another question,in .csv file the format of the column looks like this '11/03/2007', but when I am reading from seq file, it is showing only 2 digits o fthe year.Can yo...

Thanks for all of your inputs and suggestions. finally I stick with this derivation Iconv(DSLink71.HIRED, "DMDY"). I have another question , in .csv file the values of the column is '11/3/2007' in this format.but when reading from sequential file it is reading only last 2 digits of the yea...